How to Fix Shared Excel File Not Showing Changes in OneDrive
Question details
Users collaborating on a shared Excel workbook in OneDrive are experiencing delays in seeing updates from other team members.

- Product
- Microsoft Excel / OneDrive
- Device & OS
- not provided
- Scenario
- Co-authoring a shared Excel workbook with team members via OneDrive.
- Observed behavior
- Changes made by team members do not appear immediately and require multiple saves or reopening the file to sync.
Ensure that you have a stable internet connection and that the OneDrive desktop client is actively running and signed in on your computer.
Verify Office Version and Account Sign-in
Ensure all collaborators are using a compatible Microsoft 365 version that supports real-time co-authoring and are signed into the correct account.
Real-time co-authoring requires a Microsoft 365 subscription. If any user has an older standalone version of Office, they may lock the file and prevent real-time updates for everyone else.
Open the affected Excel workbook and go to File > Account in the top left corner.
Under 'Product Information', verify that your version says 'Microsoft 365' and supports co-authoring.
Under 'User Information', confirm that the account currently signed in matches the one with granted permissions to the shared OneDrive file.

Check OneDrive Sync Status
Identify and resolve any syncing issues or paused connections directly within the OneDrive application.
Test with a New Excel Workbook
Determine if the issue is specific to a corrupted file or unsupported features in the current workbook by creating a test file.
Collaborate Seamlessly with WPS Office
If Microsoft Excel and OneDrive continue to experience syncing delays, try WPS Office. It provides a lightweight, highly compatible alternative with its own reliable cloud collaboration features to keep your team on the same page.
- 1. Install the software: Download and install WPS Office on your computer or mobile device.
- 2. Open your spreadsheet: Open your existing .xlsx file using WPS Spreadsheet.
- 3. Share with your team: Click the 'Share' button in the top right corner to generate a collaboration link and invite your team members.

Frequently Asked Questions
Why does Excel say the shared file is locked for editing by another user?
This typically occurs if a collaborator is using an older version of Excel that doesn't support real-time co-authoring, or if the file contains features that disable real-time collaboration. Excel locks the file to prevent conflicting edits.
Do macros prevent real-time co-authoring in Excel?
Yes, workbooks containing macros (.xlsm files) or complex external data models can sometimes restrict real-time co-authoring in Excel, causing users to not see changes immediately until the file is manually saved.
How do I force OneDrive to sync changes manually in Excel?
You can manually trigger a sync by clicking the Save icon in the top left corner (or pressing Ctrl+S) in Excel. This forces the application to push your local changes to OneDrive and pull any pending updates from other users.




