Fix Excel Document Not Saved Error for a Shared OneDrive Workbook
Question details
Identify why one user cannot save a shared macro-enabled Excel workbook stored in OneDrive.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- Windows; versions not provided
- Scenario
- A user edits a shared macro-enabled workbook stored in OneDrive while other users access the same file.
- Observed behavior
- The affected user sees a Document Not Saved error for this workbook, but other shared files work correctly.
Ask the affected user to note when the error appears and whether other users can save the same workbook. Confirm that the file is an Excel macro-enabled workbook with an .xlsm extension.
Compare Excel versions and isolate the workbook or macros
Use these tests to determine whether the error is associated with an Office version, the workbook, or its macros.
On both computers, open Excel and select File > Account > About Excel. Compare the version and build numbers, and use Update Options > Update Now if updates are available.
Open the workbook and use File > Save As to save a separate copy as an Excel Workbook (.xlsx). Accept the warning that VBA features will not be saved, then test whether the affected user can edit and save that copy.
Have the affected user open and save another trusted .xlsm workbook from OneDrive. Compare the result with the original workbook and the macro-free copy.

Check OneDrive edit access and file syncing
Use this check to rule out permission or sync problems affecting the specific workbook.
Contact Microsoft Support with the test results
Use this option if the affected user still cannot save the workbook after the version, macro, and permission checks.
Work with Excel files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for working with Microsoft Office files. It can help you move routine spreadsheet work to WPS, but it does not fix Excel or OneDrive save errors; verify macro compatibility before migrating an .xlsm workflow.

Frequently Asked Questions
Why does only one user see Document Not Saved?
The affected user may have different Excel versions, file permissions, or OneDrive sync conditions. Compare File > Account > About Excel on both computers and check the workbook's Manage access settings in OneDrive.
How can I check whether macros are involved?
Use File > Save As to create a separate .xlsx copy and test saving it. Then test another trusted .xlsm file. The .xlsx copy will not retain VBA macros, so keep the original .xlsm file.
Where can I check whether the user has permission to edit?
Select the workbook in OneDrive on the web and open Manage access. Confirm that the affected user's access allows editing rather than viewing only.
What should I send Microsoft Support if the error persists?
Provide the exact error, Excel version and build from File > Account > About Excel, and the results of the macro-free and other .xlsm tests. Share the workbook securely if Microsoft Support requests it.




