SharePoint Document Issues

How to Fix Excel Refresh Warning for a SharePoint Workbook

Maira MehtabMaira Mehtab Nov 4, 2026 868 views

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'.

How to Fix Excel Refresh Warning for a SharePoint Workbook
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.
Before you start

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.

Solution 1

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.

1
Open Excel Options

Launch the Excel desktop application, click on 'File' in the top left corner, and select 'Options' at the bottom of the menu.

2
Navigate to Save Settings

In the Excel Options window, click on the 'Save' tab on the left-hand side.

3
Clear Cached Files

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.

Free Microsoft Office alternative

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. 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. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and directly open your existing .xlsx files without worrying about formatting loss.
  3. 3. Edit Without Interruptions: Enjoy a stable editing experience using local or cloud storage options, free from persistent desktop sync warnings.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture ensures fast load times and prevents bloated cache issues.Free to use with a familiar, tabbed interface that makes migration seamless.
microsoft office alternative - wps office

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.