How to Fix Excel Changes Not Updating in a SharePoint Workbook
Question details
Users need to resolve synchronization issues where edits to a shared Excel file do not appear for other collaborators.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook stored in SharePoint, particularly when accessing the file via indirect links (like Planner) or switching between desktop and web versions.
- Observed behavior
- Edits made by a user in the shared Excel workbook do not sync back to SharePoint, making the changes invisible to other collaborators.
Verify that your internet connection is stable and ensure AutoSave is toggled on in the top-left corner of the Excel application.
Verify Editing Methods and File Access
Ensure all collaborators are opening the original SharePoint file directly rather than an offline copy or through unsupported indirect links.
Sometimes, accessing a shared workbook through third-party integrations or indirect links (such as Microsoft Planner) forces the file to open in a read-only or unsynced state. Opening the file directly from SharePoint ensures real-time co-authoring works correctly.
Navigate to your SharePoint document library in your web browser. Locate the Excel workbook, click the three dots next to the file name, and select 'Open in Excel' or 'Open in browser'.
Ask affected users to confirm if they can see the colored cursors of other collaborators in the document. If they cannot, they may be editing a disconnected copy.
Make a test edit in Excel for the Web, then open the file in the Excel Desktop application to see if the changes populate. This helps identify if the issue is isolated to the desktop app's cache.

Clear Office Cache and Reset Credentials
Resolve underlying authentication and syncing conflicts by clearing stored Microsoft credentials and the Office document cache.
Experience Hassle-Free Document Collaboration with WPS Office
If SharePoint sync issues and Excel cache errors disrupt your workflow, consider switching to WPS Office. It is a powerful, lightweight, and free alternative to Microsoft Office that offers seamless local and cloud editing without complex sync conflicts.
- 1. Download and Install: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and easily open your existing .xlsx files with full formatting intact.
- 3. Collaborate Effortlessly: Use WPS Cloud to share links with your team for streamlined, hassle-free document collaboration.

Frequently Asked Questions
Why does Excel say 'Saved Offline' when working on a SharePoint file?
This happens when your Excel desktop application loses connection to the SharePoint server or encounters an authentication error. Check your internet connection, ensure AutoSave is turned on, and sign out and back into your Office account to refresh your credentials.
Does Excel for the Web sync differently than the Excel Desktop app?
Yes. Excel for the Web saves and syncs changes automatically and instantaneously to the server. The desktop application relies on the local Office Upload Center and requires AutoSave to be active to push changes to SharePoint continuously.
How do I force a sync in the Excel desktop app?
You can force a sync by clicking the 'Save' icon (floppy disk) in the top-left corner, or pressing Ctrl+S. If AutoSave is disabled, this action will manually push your latest changes to the SharePoint server.
Can multiple people edit an Excel file in SharePoint at the same time?
Yes, through a feature called Co-authoring. However, all users must be using a version of Excel that supports co-authoring (like Microsoft 365 or Excel for the Web) and the file must be saved in the .xlsx format.




