Excel Document Not Saved: How to Recover and Fix It

If Excel says a document was not saved, or its save appears stuck, the cause may be a connection, permissions, a full drive, or a problem with the file itself. These steps help protect your current work first, then identify the cause and save a usable copy.

What You’ll Need

Excel and access to the file’s current location, such as your computer, a network folder, or cloud storage.
A second location with enough free space, such as a local folder or an approved external drive, for a recovery copy.
If the workbook is shared, permission to save to its folder or to create a separate copy.

Step-by-Step

Protect the open workbook before troubleshooting. If the workbook is still open and you can see your latest changes, do not close Excel, restart the computer, or repeatedly force the app to quit. Try pressing Ctrl+Shift+S on Windows or Command+Shift+S on Mac to open Save As. Choose a simple local folder, such as Documents, give the file a new name, and save it in the current Excel format (.xlsx) unless it needs macros, in which case use .xlsm. If the keyboard shortcut does not open Save As, use File > Save As.
Check whether Excel is still working. A large workbook or a slow connection can make saving take longer. Look for a progress indicator or an unresponsive window, and allow it time to finish. Avoid clicking Save repeatedly or ending the task while disk activity is continuing. If Excel responds, try saving the recovery copy to a different local folder.
Read the complete error message. Note whether it mentions access, a read-only file, a file name, a location, or a connection. The wording points to the next check. If possible, take a screenshot or write down the message before dismissing it. Do not overwrite the original or delete temporary files as a first response.
Check the destination and available space. In File Explorer on Windows or Finder on Mac, confirm that the folder exists and that you can create or edit files there. Check that the drive is connected and has free space. If you are saving to a network folder, reconnect to the network or VPN required by your workplace. If you are saving to removable storage, confirm it is mounted and available. First test by saving a new copy locally rather than moving or renaming the original.
Check the file name and format. Try a shorter name using ordinary letters and numbers, and save in a folder with a short path. Make sure the extension matches the workbook’s contents: .xlsx for a standard workbook or .xlsm if it contains macros. If Excel warns that features may be lost in another format, cancel and choose the correct format rather than discarding features unintentionally.
Check access and read-only status. If the workbook or folder is read-only, or you lack permission to edit it, use File > Save As to create a copy in a folder where you have write access. On Windows, you can right-click the file in File Explorer and choose Properties to inspect its read-only setting. For a shared or managed folder, ask its owner or administrator to confirm your access instead of changing permissions you do not control.
For cloud or shared files, check the connection and sync state. Confirm that you are signed in to the account that owns or can edit the file, and that internet access is working. Check the cloud storage app or service for a paused, pending, or failed sync. Wait for syncing to resume, then save. If the original remains unavailable, save a local copy first. Avoid editing competing copies at the same time; once access returns, compare the copies before replacing anything.
Recover unsaved work if Excel closed or crashed. Reopen Excel and look for a Document Recovery pane. Open the most recent relevant version and immediately use Save As to save it under a new name. If there is no recovery pane, check File > Info > Manage Workbook or the option for recovering unsaved work, where available in your Excel version. Recovery options vary; a recovered file may not include the very latest edits.
Verify the copy before replacing the original. Close only after the new copy has saved successfully. Reopen it, check the latest changes and important sheets, and confirm that formulas and any required macros are present. Keep the original until you have checked the copy and know which version is complete.

Common Mistakes

Closing Excel or restarting immediately when the only copy of recent edits is still open.
Saving over the original before confirming that the replacement opens and contains the right changes.
Choosing .xlsx for a macro-enabled workbook; that format cannot preserve VBA macros.
Assuming a cloud save is complete just because the workbook is open. A pending sync or lost connection can leave changes unsent.
Changing folder permissions, deleting temporary files, or disabling security software without knowing the cause. These actions can create new problems and may not fix saving.

Tips

When a save fails, create a separate local recovery copy before trying more involved fixes.
Use descriptive, distinct names for recovery copies so they are easy to compare, for example Budget-recovered.xlsx.
For important workbooks, save regularly and use Excel’s AutoSave only when the file is stored in a supported cloud location and the setting is available. AutoSave does not replace checking that the latest changes have synced.
Keep a backup of critical workbooks in a separate approved location. A second copy can help if the original drive or sync service becomes unavailable.

Troubleshooting

Save As also fails: Try a different local folder and a shorter file name. If that works, the original folder, path, drive, or permissions are likely involved. If it does not, check local disk space and whether Excel can save any other workbook.

The workbook is marked read-only or locked: Another user or process may have it open, or the folder may not allow editing. Save your own copy, then ask the file owner whether it is safe to edit the original. Do not remove a lock file while someone may still be using the workbook.

The file saves but will not open: Keep an untouched copy. In Excel, use File > Open, browse to the workbook, select the arrow next to Open if shown, and choose Open and Repair. This option is not available in every version. If repair fails, try opening a separate copy or use a prior backup; avoid repeatedly modifying the only copy.

Excel crashes during saving: After securing any recoverable copy, restart Excel and check whether the problem affects one workbook or all workbooks. If it affects one, the workbook may be damaged or unusually complex. If it affects many, update Office through its available update settings and, on Windows, consider repairing Office from the installed apps settings. On Mac, use the update options available for your Office installation. If the issue continues, contact your organization’s support team or Microsoft support with the error details.

Changes are missing from a synced file: Check the service’s version history or recycle bin before overwriting anything. Restore or download the needed version as a separate copy, then compare it with the local workbook.

Frequently Asked Questions

Can I recover an Excel file that was never saved?
Possibly. Reopen Excel and check Document Recovery or the unsaved-workbook recovery option under File. Recovery depends on Excel’s saved recovery data, so the latest changes may not be available.

Should I close Excel when it says the document was not saved?
Not while the unsaved changes are visible and Excel is responsive. First try to save a separate copy. If Excel has frozen, allow time for it to respond before considering a forced close.

Why does Excel save locally but not to a shared folder?
The shared location may be disconnected, unavailable, read-only, or missing the necessary permissions. A local copy protects your work while you check access or contact the folder owner.

Will Save As keep my formulas and formatting?
Usually, when you save in a compatible Excel workbook format. Check any format warning carefully; some formats, especially CSV, do not preserve workbook features such as multiple sheets, formatting, or formulas as formulas.

What if there is no Document Recovery pane?
Check Excel’s available recovery options under File > Info > Manage Workbook. If nothing is listed, look for a backup or cloud version history. Excel may not have a recoverable copy.

How can I tell the file really saved?
Wait for Excel’s save or sync indicator to finish, then reopen the saved copy and check the latest changes. For cloud files, also confirm the service reports that syncing is complete.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →