OneDrive File Issues

Fix Excel Document Not Saved Error for a Shared OneDrive Workbook

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

Identify why one user cannot save a shared macro-enabled Excel workbook stored in OneDrive.

Fix Excel Document Not Saved for a Shared OneDrive Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Compare Office versions

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.

2
Test a macro-free copy

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.

3
Test another macro-enabled file

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.

Compare Excel versions and isolate the workbook or macros
Keep the original macro-enabled file: The .xlsx test copy cannot retain VBA macros. Do not replace the original .xlsm workbook with it.
Free Microsoft Office alternative

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.

Open and edit common Microsoft Excel formats, including .xlsx filesUse familiar spreadsheet tools for everyday workbook editingMove routine spreadsheet work to a lightweight, free office suiteReview macro-dependent workflows separately before switching
microsoft office alternative - wps office

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.