Forum Discussion

Lclift61's avatar
Lclift61
Copper Contributor
Mar 15, 2021

Syncing Issues for specific users when Opening in the Desktop App

Hello - I'm experiencing issues with Excel Online files not syncing correctly for certain users when they have been accessing them through the Desktop App. I'll try to describe the precise details to paint the picture.

 

We have a number of Excel Online spreadsheets. These are accessed by Users through Teams and on private channels but are hosted on SharePoint as with all Teams files. Users are able to access and update fine through Teams itself but for certain reasons they need to open regularly in the Desktop App for additional Excel Functionality (refreshing data connections for instance).

 

One user in particular has found that when she has opened a file in the desktop app and makes changes these are not pushed back up to SharePoint although the file is saying it has saved. If she opens the file again in the Desktop App from teams it also does not show changes made by other users or herself on Teams.

 

It appears that a local copy is being cached and that her profile is somehow reverting always to the cached version and not pushing changes to SharePoint. We found that Syncing the SharePoint folder to OneDrive helped initially and I then asked her to access the file through a pinned Excel link in the Taskbar but when she used a different PC the problem started occurring again.

 

We have increasing numbers of shared sheets being used accros the organisation therefore I need to get to the bottom of why certain users are experiencing this issue and what we can do to resolve.

 

 

Any advice would be greatly appreciated. 

  • Hello Lclift61 


    I have had such issue with one colleague of mine, always the same Team and the same Excel Sheet and only that particular user. Opening the sheet in the desktop app resulted in showing an older version even though it said it´s up to date and changes are saved. Opening in Teams or Excel web app, revealed that there are newer changes and the desktop app was showing days/week old versions.

     

    There are several places to check now, and which I went through to solve it. In my case it was the first option, a pending upload which somehow got stuck.


    1. Check if there any pending uploads in the "Upload Center" (little orange icon in the taskbar). Cancel them necessary.


    2. Delete local cache files

    • \appdata\local\temp
    • \appdata\local\microsoft\office\unsavedfiles

    3. Delete server cache from registry

    • HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Internet\Server Cache

     

    Assuming you´re using current Office 365 installation and everything is updated.

     

    Michael

     

    EDIT: Office Upload Center has been removed, please see my reply below.

    Go to reply 

Resources