Fix Excel Co-Authoring Not Showing Other Users' Changes
Question details
Users are experiencing issues where Excel co-authoring fails to display edits and real-time changes made by other collaborators.

- 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.
Ensure you have a stable internet connection and verify that AutoSave is turned on in the top-left corner of the Excel window.
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.
Open your workbook in Excel, click 'File' > 'Save As', and select 'OneDrive' or 'SharePoint' to ensure the file is in a supported location.
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.
Click the 'Share' button in the top right corner, enter your collaborators' email addresses, and ensure they have 'Can edit' permissions.

Remove Unsupported Features like Macros and VBA
Certain legacy features, macros, and VBA scripts can block simultaneous editing and prevent real-time synchronization.
Update Microsoft Excel to the Latest Build
Outdated versions of the Excel desktop application may lack the necessary updates to support real-time co-authoring features.
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. Download and Install: Download WPS Office Free from the official website and complete the installation.
- 2. Open your Spreadsheet: Open your existing .xlsx files directly in the WPS Spreadsheet application.
- 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.

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.




