SharePoint opens different versions of files in the desktop app and the browser

Hello,

I am experiencing two problems with Excel files on SharePoint. I have File A, which is linked via formulas to File B (File A serves as an input for File B). I am using Excel 365.

Problem 1: Sync and Loading Issues with File A

When I open File A using the desktop app, Autosave is enabled, and I can see other users working in the file (their cursors are visible). However, I do not see the changes they make.

When I open the same file in a browser, I do not see myself listed as working on the desktop app, nor do I see the changes I’ve made in the desktop app. Additionally, when I try to close the desktop app, I receive the error message shown in the screenshot, but the loading process never completes.

If I cancel the loading process and reopen File A in the desktop app, it displays the version I had previously saved via the desktop app. Furthermore, if I download the file from SharePoint, it matches the browser version. When working on Files A and B simultaneously in the desktop app, changes made in File A correctly affect File B.

Problem 2: File B is based on desktop version of File A

When I open File B, it displays the input from the desktop version. However, the other user sees the input from the browser version of File A.