Fix SharePoint Excel Files Showing Different Versions in Desktop and Browser
Question details
The user is experiencing synchronization issues where an Excel file on SharePoint displays different content when opened in the desktop application versus the web browser.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on or editing Excel files hosted on SharePoint using both the desktop client and web platforms.
- Observed behavior
- Edits made in one platform (desktop or browser) are not reflecting in the other, causing version conflicts and mismatched data.
Ensure you have a stable internet connection and verify that you are logged into both the Excel desktop app and your web browser with the same Microsoft 365 account.
Enable AutoSave and Allow Time for Synchronization
Ensuring AutoSave is active guarantees real-time syncing between the desktop app and SharePoint, preventing version mismatches.
When AutoSave is disabled, changes made in the desktop application are only synchronized to SharePoint when the file is manually saved or closed. Enabling AutoSave ensures continuous background syncing.
Open the affected Excel file in your desktop application directly from the SharePoint document library.
Locate the AutoSave toggle switch in the top-left corner of the Excel window (above the ribbon) and turn it on.
Go to File > Info and ensure the file path indicates it is actively connected to the correct SharePoint URL.
Look at the status bar at the bottom or the save icon at the top to ensure it says 'Saved to SharePoint'. Do not close the app while it says 'Saving...'.

Manually Save and Refresh the Browser Version
If AutoSave is disabled or fails, manually saving and refreshing forces the servers to update the file version.
Try WPS Office for Seamless File Collaboration
If you frequently encounter synchronization issues and version conflicts with Microsoft Excel and SharePoint, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with its own reliable cloud synchronization features.

Frequently Asked Questions
Why does my Excel file say it's locked for editing by another user on SharePoint?
This happens if someone left the file open in their desktop app without AutoSave enabled, or if SharePoint hasn't registered that a user closed the file. Ask the user to close the file or wait a few minutes for the server timeout.
Can I force SharePoint to sync my Excel file?
Yes, in the desktop app, you can manually click the Save button. Alternatively, if you are using the OneDrive sync client for SharePoint, you can right-click the OneDrive icon in your system tray and select 'Sync now'.
What happens if two people edit the same cell at the same time in SharePoint?
SharePoint and Excel will attempt to merge the changes. If a direct conflict occurs, Excel will prompt you with a 'Resolve Conflicts' dialog box, allowing you to choose which version of the cell's data to keep.




