SharePoint Document Issues

How to Fix Excel Asking to Merge Changes with Server Updates

Steven ParkerSteven Parker Oct 28, 2026 868 views

Question details

The user needs to resolve an issue where Excel constantly prompts to merge changes with the server version when collaborating on a cloud-stored file.

How to Fix Excel Asking to Merge Changes with Server Updates
Product
Microsoft Excel, SharePoint, Teams
Device & OS
not provided
Scenario
Saving a collaborative workbook that is stored and accessed via a cloud environment like SharePoint or Microsoft Teams.
Observed behavior
Excel displays a warning message asking the user to merge their changes with the latest server updates, preventing a normal save operation.
Before you start

Before attempting to resolve sync conflicts, use 'Save As' to save a local copy of your workbook to your desktop to ensure your recent edits are not lost during the troubleshooting process.

Solution 1Recommended

Resolve Conflicts in 'Files Needing Attention'

Use Excel's built-in document conflict resolution menu to clear cached versions that are blocking the save process.

This error typically occurs when Excel opens a cached or conflicting version of the workbook. Excel flags these files so you can manually decide which version of the data to keep.

1
Open the File Menu

With the problematic workbook open in Excel, click on the 'File' tab located in the top-left corner of the window.

2
Navigate to the Open tab

Select 'Open' from the left-hand navigation pane.

3
Check Files Needing Attention

Look for a section titled 'Files Needing Attention'. This section only appears if Excel detects sync issues or local cache conflicts.

4
Resolve or Discard Conflicts

Click on the listed file. You will be prompted to either resolve the conflicts manually by comparing changes or discard your local changes so Excel can fetch the latest online version.

Sync Restored: Once the conflict is resolved or discarded, Excel will resume normal saving and syncing with the SharePoint or Teams server.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Editing

If you frequently encounter frustrating sync errors, server conflicts, and cache issues in Microsoft Excel, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that makes managing and sharing spreadsheets hassle-free.

  1. 1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your computer.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly. You can easily drag and drop files into the workspace.
  3. 3. Save and Sync: Use WPS Cloud to safely back up your files and access them across multiple devices without frustrating version conflicts.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) ensuring zero formatting loss.Lightweight installation with a fast, responsive, and familiar user interface.Built-in robust cloud syncing for smooth document management without complex server conflicts.Completely free to use, saving you from expensive subscription fees.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel think my file is out of sync with SharePoint?

This usually happens when multiple people edit a collaborative file simultaneously, or if your local Office cache fails to upload your changes before someone else saves theirs, creating a version conflict.

Will I lose my data if I discard local changes?

Yes, clicking 'Discard changes' will overwrite any unsaved local edits you made with the current version residing on the SharePoint or Teams server. Always use 'Save As' to keep a local backup if you need to preserve your work.

How can I prevent server merge conflicts when using Teams?

To minimize conflicts, ensure the 'AutoSave' toggle is turned on in the top-left corner of your Excel window. Additionally, avoid leaving collaborative files open on your computer when you disconnect from the internet or put your device to sleep.

What if 'Files Needing Attention' is empty but I still get the error?

If the menu is empty, the issue is likely a stuck OneDrive sync process or a corrupted Office cache. You can resolve this by clearing the Office document cache in Excel Options or by pausing and resuming your OneDrive sync.