How to Fix Excel Document Not Saved Error

This guide walks you through the most common causes of the “Excel document not saved” error and provides clear, step-by-step fixes to recover your work and prevent future losses. You’ll need access to your Excel file, the folder where it’s stored, and possibly a backup location. No advanced technical skills are required.

What You’ll Need

• Your Excel file (or the folder where it was last saved)
• Access to your computer’s file system (File Explorer on Windows, Finder on Mac)
• If the file is on a network drive or cloud storage, you may need access to that service
• Optional: A USB drive or another folder for backup copies

Step-by-Step

1. Check for an AutoRecover copy. Open Excel (a blank workbook is fine). Go to File > Info and look for the Manage Workbook button. Click it and select Recover Unsaved Workbooks. If a copy appears, open it and save it immediately with a new name.
2. Search the default AutoRecover location. If the above doesn’t work, go to File > Options > Save. Note the path under AutoRecover file location. Open that folder in File Explorer/Finder. Look for files with the .xlsb or .xlsx extension, or files named like “AutoRecover save of Book1”. Copy any that look relevant to your document, then open them in Excel.
3. Check the Recycle Bin or Trash. If the file was deleted (sometimes Excel deletes a temp file when it crashes), right-click the Recycle Bin (Windows) or Trash (Mac) and select Open. Look for your file name or a file with a similar name and a .tmp or .xlsx extension. If found, right-click and choose Restore.
4. Look for temporary files. In the same folder where your Excel file is stored, look for files that start with a tilde (~) followed by a dollar sign ($), like ~$MyWorkbook.xlsx. These are temporary lock files. They usually don’t contain your data, but sometimes they do. Open them in Excel and see if your content is there.
5. Check cloud storage version history. If your file is in OneDrive, SharePoint, or Google Drive, right-click the file in the cloud folder and look for Version History or History. Select an earlier version and download or restore it.
6. Disable the “Save AutoRecover information every” setting if it’s causing issues. Some users find that AutoRecover can interfere with normal saving. Go to File > Options > Save. Uncheck Save AutoRecover information every and Keep the last autosaved version if I close without saving. This is a last resort, as it disables a useful safety net.
7. Repair the file. If you can see the file but it won’t open, open Excel, go to File > Open, select the file, and click the arrow next to Open. Choose Open and Repair. Then select Repair or Extract Data.
8. Save to a new location. If you get the error when saving, try saving to a different folder (e.g., your Desktop) or with a different file name. This can bypass a corrupted file path or a permissions issue.

Common Mistakes

• Ignoring the AutoRecover option. Many users don’t realize that Excel’s AutoRecover is disabled by default or set to save every 10 minutes. Check your settings and set it to save every 1-2 minutes.
• Not saving a backup copy. Relying on a single file is risky. Always keep a backup on a different drive or cloud service.
• Deleting temporary files immediately. When Excel crashes, it may leave temp files. Don’t run a disk cleanup right away; you might delete a recoverable copy.
• Opening the file in a different program. If you open an .xlsx file in a text editor or a different spreadsheet program, it can corrupt the file structure. Always use Excel.

Tips

• Use AutoSave with OneDrive. If you save your files to OneDrive, enable AutoSave (the toggle at the top of Excel). This saves continuously and lets you recover previous versions easily.
• Customize the AutoRecover interval. Go to File > Options > Save and set Save AutoRecover information every to 1 minute. This minimizes data loss.
• Use the “Save As” shortcut. Get into the habit of pressing F12 (Windows) or Shift+Command+S (Mac) to save a new copy at important milestones.
• Keep your software updated. Excel updates often fix bugs that cause saving errors. Enable automatic updates in your Office settings.

Troubleshooting

If the above steps don’t recover your file, try these additional measures:

• Check if the file is locked by another process. If you see a message like “File in use” or “Permission denied”, close all other Excel windows, or ask other users to close the file if it’s on a shared drive.
• Run Excel in Safe Mode. Press Windows + R, type excel /safe, and press Enter. If Excel opens without issues, a third-party add-in might be causing the problem. Disable add-ins via File > Options > Add-ins.
• Check your disk space. If your hard drive is full, Excel can’t save. Free up space and try again.
• Check file permissions. Right-click the folder where the file is stored, select Properties, and ensure you have write permission. If not, change the security settings or save to a different location.
• Use a file recovery tool. If nothing else works, third-party data recovery software may be able to scan your drive for deleted Excel files. Use such tools cautiously and only from reputable sources.

Frequently Asked Questions

Why does Excel keep saying “Document not saved”?

This usually happens when Excel can’t write to the file location—due to insufficient permissions, a full disk, or a network connection issue—or when the file is corrupted.

Can I recover an unsaved Excel file after a crash?

Yes, if AutoRecover was enabled. Open Excel, go to File > Info > Manage Workbook > Recover Unsaved Workbooks. If that fails, check the AutoRecover file location in Excel’s options.

Where does Excel store AutoRecover files?

By default, it’s in a folder like C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\ on Windows, or /Users/[YourName]/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Excel/ on Mac. You can find the exact path in Excel options under Save.

What’s the difference between AutoSave and AutoRecover?

AutoSave continuously saves your file to OneDrive or SharePoint as you work. AutoRecover creates periodic snapshots of the file locally, which you can use to recover after a crash. AutoSave is more reliable if you use cloud storage.

Will I lose my data if I close Excel without saving?

If AutoRecover is enabled, Excel keeps the last autosaved version. When you reopen Excel, it may show a “Document Recovery” pane with the unsaved file. If not, go to File > Info > Manage Workbook.

How do I prevent this error in the future?

Enable AutoSave (if using OneDrive), set AutoRecover to save every 1 minute, regularly save with Ctrl+S, and keep a backup copy on a separate drive or cloud service.

Related

• Turn Android Phone Into Chromecast: Full Guide
• Rockstar Error Code? Fixes for Launcher & Social Club
• Discord Stuck at RTC Connecting? Fixes That Work