How to Fix Excel Refresh Warning for a SharePoint Workbook
Question details
Users encounter a persistent refresh warning when opening a SharePoint-hosted Excel workbook in the desktop app, restricting saving options to 'Save a Copy' or 'Discard Changes'.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening and attempting to sync an Excel workbook hosted on SharePoint via the Excel desktop application.
- Observed behavior
- The Excel desktop app repeatedly displays a refresh warning and refuses to save changes to the original file, offering only the options to 'Save a Copy' or 'Discard Changes', despite the file functioning normally in the web browser.
Ensure that the workbook is closed on all other devices and verify with your team that no other users are currently editing the file in SharePoint.
Clear the Excel Document Cache
Deleting corrupted or outdated cached files can resolve synchronization conflicts between the Excel desktop app and SharePoint.
Often, temporary sync files get stuck or corrupted, leading Excel to incorrectly believe that the server version conflicts with your local version.
Launch the Excel desktop application, click on 'File' in the top left corner, and select 'Options' at the bottom of the menu.
In the Excel Options window, click on the 'Save' tab on the left-hand side.
Scroll down to the 'Cache Settings' section and click the 'Delete cached files' button. Click 'OK' to confirm and restart Excel before opening the SharePoint file again.
Replace and Rename the SharePoint File
If clearing the cache fails, creating a fresh copy of the workbook and renaming it bypasses the broken sync state.
Edit Spreadsheets Seamlessly with WPS Office
Tired of encountering complex server sync errors and refresh warnings? Switch to WPS Office. As a free, lightweight, and user-friendly alternative to Microsoft Office, WPS provides robust spreadsheet features without the heavy cache conflicts.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the on-screen instructions to set it up on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and directly open your existing .xlsx files without worrying about formatting loss.
- 3. Edit Without Interruptions: Enjoy a stable editing experience using local or cloud storage options, free from persistent desktop sync warnings.

Frequently Asked Questions
Why does the Excel desktop app force me to 'Save a Copy' or 'Discard Changes'?
This happens when the Excel desktop application detects a version conflict or sync failure with the SharePoint server. It restricts you from saving directly to prevent overwriting someone else's changes or corrupting the server file.
Will clearing the Excel document cache delete my actual files?
No. Clearing the document cache only deletes hidden, temporary sync files used by Office to speed up background saving. It does not affect or delete your actual workbooks or personal data.
Can multiple users edit a SharePoint workbook at the same time without errors?
Yes, Microsoft supports co-authoring for SharePoint files. However, if a user is running an outdated version of Excel, or if someone leaves the file open with unsaved changes, it can trigger sync warnings and lock the file for others.





