How to Fix Excel Not Displaying the Latest SharePoint Workbook Version
Question details
The Excel desktop application is showing an older version of a workbook compared to the newer modification date shown on the SharePoint page.

- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Opening a shared workbook from SharePoint in the Excel desktop application.
- Observed behavior
- The Excel desktop app displays an outdated version of the workbook, failing to sync or load the most recent modifications from SharePoint.
Ensure you have a stable internet connection and verify that your Microsoft 365 account is properly signed in to both your browser and the Excel desktop application.
Open Directly from SharePoint Web and Verify Version History
Bypass local caching issues by launching the workbook directly from the SharePoint web interface to force a fresh connection.
Often, opening a file from the 'Recent' list in Excel loads a locally cached version instead of checking the server. Opening directly from SharePoint ensures you are accessing the live file.
Open your web browser, log into your Microsoft 365 account, and navigate to the SharePoint document library where the workbook is stored.
Click on the Excel workbook to open it in Excel for the Web. Check the data to confirm that this browser version reflects the latest modifications.
Look at the top ribbon in Excel for the Web and click the 'Editing' dropdown or 'Open in Desktop App' button to force the local Excel application to fetch the current version directly from the server.

Clear the Local Office Document Cache
Clear cached files in the Excel settings to resolve conflicts preventing the latest SharePoint version from downloading.
Try WPS Office for Seamless Cloud Document Management
If you frequently experience synchronization issues and cached version conflicts with Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with robust built-in cloud integration for reliable document management without the sync headaches.

Frequently Asked Questions
Why does my Excel file say 'Saved' but SharePoint doesn't show the updates?
This often happens if the Microsoft Office Upload Center is paused, experiencing a sync error, or if you are working offline. Check the system tray (bottom right corner of your Windows taskbar) for the Upload Center icon to resolve any pending sync conflicts.
How can I view previous versions of an Excel file in SharePoint?
Navigate to your SharePoint document library, click the three dots (ellipses) next to the Excel file name, and select 'Version History'. A pane will appear showing all past versions, which you can view or restore.
Does clearing the Office cache delete my personal files?
No, clearing the Office document cache only removes temporary files that Office uses to facilitate syncing and offline editing. It does not delete the actual documents stored on your local hard drive or on SharePoint.
How do I force a sync between Excel desktop and SharePoint?
You can force a sync by ensuring 'AutoSave' is toggled on at the top left corner of the Excel window. Alternatively, closing the file and reopening it directly from the SharePoint web interface will force the app to fetch the latest server copy.




