File Sharing Problems

Fix Excel Co-Authoring Not Showing Other Users' Changes

Steve KSteve K Oct 28, 2026 869 views

Question details

Users are experiencing issues where Excel co-authoring fails to display edits and real-time changes made by other collaborators.

How to Fix Excel Co-Authoring Not Showing Other Users' Changes
Product
Excel
Device & OS
not provided
Scenario
Collaborating on a shared Excel workbook with multiple users simultaneously.
Observed behavior
Edits and changes made by other users are not visible in real-time or fail to sync entirely during a co-authoring session.
Before you start

Ensure you have a stable internet connection and verify that AutoSave is turned on in the top-left corner of the Excel window.

Solution 1Recommended

Verify Cloud Storage and Supported Accounts

Real-time co-authoring requires the workbook to be hosted on Microsoft's cloud services and all users to be properly signed in.

Excel cannot co-author files saved locally on your computer's hard drive or on unsupported third-party cloud platforms. It must be stored in Microsoft OneDrive, OneDrive for Business, or SharePoint Online.

1
Save to the cloud

Open your workbook in Excel, click 'File' > 'Save As', and select 'OneDrive' or 'SharePoint' to ensure the file is in a supported location.

2
Verify account sign-in

Check the top right corner of the Excel window to confirm you are signed in with a Microsoft 365 account that has the appropriate permissions.

3
Re-share the file

Click the 'Share' button in the top right corner, enter your collaborators' email addresses, and ensure they have 'Can edit' permissions.

Verify Cloud Storage and Supported Accounts
Account Consistency: All co-authors must be using a version of Excel that supports co-authoring, such as Microsoft 365, Excel for the web, or mobile apps.
Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

If Excel's co-authoring features are consistently causing synchronization issues, try WPS Office. It provides a lightweight, highly compatible alternative with built-in cloud collaboration tools, ensuring you can work on spreadsheets with your team in real time without the hassle.

  1. 1. Download and Install: Download WPS Office Free from the official website and complete the installation.
  2. 2. Open your Spreadsheet: Open your existing .xlsx files directly in the WPS Spreadsheet application.
  3. 3. Share and Collaborate: Save the file to WPS Cloud and click 'Share' in the top right corner to invite your team for real-time collaboration.
Highly compatible with Microsoft Excel formats (.xlsx, .xlsm)Free and lightweight alternative to Microsoft OfficeReal-time cloud collaboration and seamless file sharingFamiliar user interface for quick and easy migration
microsoft office alternative - wps office

Frequently Asked Questions

Why is AutoSave disabled when I open a shared Excel file?

AutoSave may turn off automatically if the file is not stored in OneDrive or SharePoint, if it contains unsupported features like legacy macros, or if strict file protections and passwords are applied.

Can I co-author an Excel file that contains macros (.xlsm)?

Yes, but with limitations. Excel for the web can open macro-enabled files but cannot run or edit the VBA code. To edit macros while maintaining shared access, users must open the file in the Microsoft 365 desktop app, though complex VBA can still disrupt real-time syncing.

Does Excel co-authoring work on older versions of Office?

No, real-time co-authoring requires a Microsoft 365 subscription and current Office builds. Older standalone versions like Office 2016 or 2019 may only support legacy shared workbook features, which require you to save the file manually to see other users' changes.