Fix SharePoint Excel Desktop App Opening an Old Version
Question details
Users need to resolve an issue where launching a shared Excel workbook from SharePoint or a browser opens an outdated version in the desktop app.
- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- A user selects 'Open in desktop app' for a workbook hosted on SharePoint or OneDrive, intending to edit the most current version.
- Observed behavior
- The Excel desktop app loads an older, locally cached version of the file rather than the updated version visible in the web browser.
Verify that your Microsoft Office desktop application is signed into the exact same Microsoft 365 account that you are using to access SharePoint on the web.
Open the File Directly from the Excel Desktop App
Bypass the browser prompt and force Excel to fetch the latest server version by opening the file natively from within the desktop application.
When you use the 'Open in desktop app' button from a browser, Excel may default to a cached local copy if the connection is interrupted. Opening it directly via the application's built-in cloud navigation ensures Excel retrieves the latest SharePoint data.
Open the Microsoft Excel desktop application from your computer's Start menu or taskbar before opening any files.
Click on 'File' in the top-left corner of the screen, then select 'Open' from the left-hand sidebar menu.
Click on your connected SharePoint 'Sites' or 'OneDrive' location. Browse through the folders to locate your specific workbook and click to open it.
Verify Version History and Enable AutoSave
Check the document's metadata to confirm its current state and activate AutoSave to prevent future sync disparities.
Download a Copy and Re-upload to SharePoint
If the file's sync connection remains permanently broken or corrupted, generate a fresh copy from the web browser.
Try WPS Office for Seamless Cloud Collaboration
If you are tired of dealing with sync errors and cached file conflicts in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with built-in cloud support, allowing you to easily view, edit, and collaborate on your spreadsheets without desktop app syncing issues.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without worrying about formatting loss.
- 3. Save to WPS Cloud: Use the integrated WPS Cloud to safely store your documents and ensure you always open the most updated version.
Frequently Asked Questions
Why does Excel open an old version of my SharePoint file?
This usually occurs because Excel relies on the Office Document Cache to load files quickly. If the cache fails to sync properly with the SharePoint server, the desktop app opens the locally stored, outdated version instead of downloading the latest one.
How do I clear the Microsoft Office Document Cache?
You can clear the cache by opening any Office application, navigating to File > Options > Save, scrolling down to the Cache Settings section, and clicking the 'Delete cached files' button.
Does this caching issue affect all users sharing the workbook?
It can vary. If the issue is localized to a single user's device, only their cache is corrupted. However, if the file is locked or experiencing a server-side sync conflict, multiple users may encounter errors when attempting to open it in the desktop app.
Should I turn off AutoSave to prevent version conflicts?
No. It is highly recommended to keep AutoSave enabled for files hosted on SharePoint and OneDrive. Disabling it can cause further sync delays and increase the likelihood of generating conflicting copies.
