If saving fails in Excel, keep the workbook open and try File > Save As > Browse to save a copy in a different folder under a new name, preferably on your computer. If that also fails, copy the important sheets or data into a new workbook and save it before closing the original; do not assume the latest changes are recoverable until you confirm the new file opens.
What a save failure means
Save failed is a general description, not one specific Excel error. Excel may show a message such as Document not saved, an access or permission warning, a sharing conflict, or an error that mentions the file format. The cause can be the destination, the workbook, a connection, or a restriction on who may edit the file. The exact wording helps narrow down the issue, but the safest first move is the same: preserve the open work before troubleshooting.
Saving updates the workbook at its current location. Save As creates a separate file or changes the destination, which is why it is a useful test: if the new copy saves, the original location or file is a likely problem. If neither route works, try to get the contents into a clean workbook while Excel still has them in memory. Avoid closing Excel, restarting the computer, or repeatedly overwriting the original until you have a verified copy.
Try these steps before closing the workbook
- Use File > Save As > Browse, select a folder you can access, enter a different file name, and choose a suitable format. On Windows, F12 opens the Save As dialog in desktop Excel. On Mac, use File > Save As; Command+S saves the current file.
- If the file is in OneDrive, SharePoint, a network folder, or an external drive, save a temporary copy to a local folder such as Documents. This separates a connection or permission issue from a problem with the workbook itself.
- If saving a copy fails, create a blank workbook with Ctrl+N on Windows or Command+N on Mac. Copy the essential data from the old workbook into it, then try saving the new file locally. Copy sheets one at a time if the workbook is large or contains complicated objects.
- After the copy saves, close and reopen that copy to check that it contains the expected sheets, formulas, and recent changes. Only then continue diagnosing the original.
When copying, decide whether you need formulas, formatting, charts, or just the displayed values. Copying cells normally preserves formulas and formatting, but external links, macros, queries, connections, and some workbook-level settings may not transfer cleanly. A copied range is a rescue copy, not necessarily a complete replacement for the original workbook.
Check the folder, file name, and permissions
A common cause is that Excel cannot write to the chosen destination. The folder may be read-only, your account may lack permission, or a company policy may restrict changes. A file opened from an email attachment, a shared drive, or a protected location can also behave differently from a file saved in your own documents folder. Try a location where you normally create files, and check that you have enough available storage.
Review the name and location as well. Windows does not allow these characters in file names: backslash, slash, colon, asterisk, question mark, quotation mark, less-than sign, greater-than sign, and vertical bar. A name cannot end with a space or period. Long, deeply nested folder paths may also cause trouble in some environments, so test with a short name in a simple local folder.
If the workbook is marked read-only, check its title bar or the file’s properties and the folder’s permissions. Another person may have the file open, or a shared location may have locked it for editing. Do not remove a company-managed restriction or change file permissions without authorization. If the workbook is stored on a network drive, ask whether the drive is connected and whether your account still has write access.
OneDrive, SharePoint, and AutoSave issues
AutoSave in Microsoft 365 works with eligible files stored on OneDrive or SharePoint. It is different from AutoRecover: AutoSave writes changes to a cloud-stored workbook as you work, while AutoRecover keeps periodic recovery information that may help after a crash. AutoSave being switched on does not prove that every recent change reached the server; a connection interruption, sign-in issue, storage limit, or sync conflict can prevent updates.
Check whether Excel shows a connection, upload, or sign-in warning, and confirm that the file is in the intended OneDrive or SharePoint location. If the service is unavailable, preserve a local copy with Save As when possible. Avoid making separate edits in multiple copies and later assuming Excel will merge every change automatically. If a conflict copy appears, compare the files and retain the needed edits before deleting either one.
In Excel for the web, changes generally save to the cloud as you work, but a lost connection can leave edits unsynced. Check the connection and the save or sync status before closing the browser tab. Menu names and available recovery options differ from desktop Excel, so if web Excel cannot complete the save, try opening the file in the desktop app if your account and organization allow it, then save a separate copy.
Recover changes that were not saved
If Excel or Windows closed unexpectedly, reopen Excel and look for the Document Recovery pane. Open the newest relevant recovered version and immediately save it with a new name. If the pane does not appear, desktop Excel for Windows may offer File > Info > Manage Workbook > Recover Unsaved Workbooks. The exact options can vary by version and workbook state; this route is not a guaranteed archive of every unsaved edit.
AutoRecover settings are under File > Options > Save in Excel for Microsoft 365 on Windows. There you can review how often recovery information is saved and the AutoRecover file location. A shorter interval can reduce the amount of work at risk after a crash, but recovery files may still be missing, incomplete, or older than the last edits. On Mac, Excel has its own AutoRecovery behavior and settings vary by release; do not rely on a Windows menu path there.
For a workbook that was saved before but now has unwanted changes, check whether it is stored in OneDrive or SharePoint and whether version history is available. Version history can let you inspect or restore an earlier cloud version, subject to the service and account settings. Before restoring, save a separate copy of the current version so that useful newer changes are not discarded. A file that was never successfully saved may not have a cloud version to restore.
When the workbook or format is the problem
If a new blank workbook saves but the original does not, the original may contain damaged content or features that complicate saving. Try saving a copy with a new name and, if appropriate, use File > Open to open a separate copy rather than experimenting on the only version. Large workbooks with many images, pivot tables, external links, or connections can also take longer to save and may expose storage or resource limits.
Check that the file type matches what the workbook contains. Excel Workbook (.xlsx) does not store VBA macros. If the workbook contains macros you need to keep, save it as Excel Macro-Enabled Workbook (.xlsm); choosing .xlsx can remove the macros. Older Excel 97–2003 Workbook (.xls) has compatibility limits, so use it only when required by the recipient or system. If Excel warns that features may be lost, read the warning before confirming the format change.
If the file opens in Protected View, editing is restricted until you choose Enable Editing, when that option is appropriate and the file is trusted. Do not enable editing for an unexpected attachment simply to bypass a warning. If the workbook is password-protected or controlled by an organization, use the authorized password or contact the owner or administrator instead of trying to bypass the restriction.
A reliable troubleshooting order
Change one thing at a time so you can identify the cause. First test a new local copy. If it saves, investigate the original folder, cloud connection, or permissions. If it does not, test a new blank workbook. If that saves, focus on the original workbook’s content or format. If even a blank workbook cannot save locally, check available disk space, Excel’s sign-in or activation status, and whether security software or an organization policy is blocking file creation. For a managed work computer, contact IT before changing security settings.
Once your work is safe, restart Excel and install available Microsoft 365 updates if the problem persists. If the failure happens only with one workbook, ask the file owner for an intact copy or try opening a duplicate. If it affects every workbook, record the full error message, the save location, the file type, and whether a local test works; those details help support staff distinguish a workbook issue from a device or account issue.
Preventing future save problems
- Save early with a clear file name, then use Ctrl+S on Windows or Command+S on Mac as you work.
- Keep important work in a location with reliable access and sufficient storage. For cloud files, confirm that sync has completed before disconnecting or shutting down.
- Review AutoRecover under File > Options > Save on Windows, and remember that recovery information is a fallback, not a substitute for saving.
- Use the correct extension, especially .xlsm for macro-enabled workbooks, and keep a separate backup before major edits or format conversions.
- For critical shared workbooks, agree on where the authoritative file lives and avoid editing competing downloaded copies.
Frequently Asked Questions
Why does Excel say Document not saved?
It means Excel could not complete the write, but the message alone does not identify why. Common causes include a read-only or unavailable destination, missing permissions, a sync or network problem, insufficient storage, or an issue with the workbook. Save a separate copy locally first, then use the location and workbook tests above to narrow it down.
Will AutoRecover restore everything I typed?
Not necessarily. AutoRecover saves recovery information periodically, so changes made after the latest recovery point may be missing. It may also be unavailable if recovery files were not created or were removed. Check the Document Recovery pane or Recover Unsaved Workbooks, then save any recovered version under a new name.
Is AutoSave the same as AutoRecover?
No. AutoSave is intended to update eligible Microsoft 365 files stored on OneDrive or SharePoint as edits are made. AutoRecover keeps periodic recovery information that may help after an unexpected closure. Neither feature should be treated as proof that a particular unsaved change is safely stored.
Can I close Excel after a save error?
Wait until you have saved and reopened a copy, or recovered the needed content elsewhere. Closing may discard unsaved changes, and recovery is not guaranteed. If Excel is still responsive, use Save As or copy essential data into a new workbook before quitting.
Why can I save other workbooks but not this one?
The issue may be specific to the file: its contents, format, protection, size, or location can prevent saving even when Excel otherwise works. Test a local copy and a blank workbook, and check format warnings. If a clean copy still fails, ask the owner for another version or contact your support team with the exact error text.
Related
- Quick Way to Shade Every Other Row in Excel Automatically
- Capitalize First Letter in Excel Quickly
- Quick Search in Excel: Find Data Fast
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Outlook Folder Link Not Working? Causes and FixesIf an Outlook hyperlink to a folder will not open, first check what kind of folder it points…
- Excel #REF! Error: How to Find and Repair the FormulaTo find a #REF! error in Excel, press Ctrl+F, search for #REF!, and choose Find All; then inspect…
- Excel Circular Reference Keeps Popping Up? Fix ItIf Excel keeps showing a circular reference warning, a formula is referring to its own cell either directly…
- Why Is the Dollar Sign Not Working in Excel Formulas?The dollar sign in Excel has two common jobs: it can display a number as currency, or it…
- TRIM Excel Not Working? Fix Spaces That TRIM MissesIf TRIM appears not to work in Excel, the text may contain a character that TRIM does not…
- Excel Page Break Not Removing? How to Fix ItIf an Excel page break will not go away, first check whether it is a manual break or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.