Forum Discussion

Peter0's avatar
Peter0
Copper Contributor
Dec 06, 2024

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. 

Excel
Formulas and Functions
office 365
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Dec 09, 2024

    Things to consider:

    Does every user enabled Autosave?

    If not then their changes will be synched after closing the file. Or they have to save manually every now and then.

     

    Sharepoint synchs in small portions in order to give everyone an equal chance to upload/save/synch their files.

    The more users and the bigger the files the longer it takes.

    So, better not cancel the synching.

Resources