A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Try these steps in order:
- Save the workbook with a new name:
- In Excel, go to File > Save As.
- Save it with a unique file name.
- If this works, the original file or save process for that file is likely being interrupted.
- Save to a different location:
- Save the file to another local folder or another drive.
- Excel saves by creating a temporary file in the destination folder, deleting the original file, and then renaming the temporary file. If that process is interrupted, the workbook may not save correctly.
- Check free disk space:
- Make sure the destination drive has enough free space.
- If the disk is full, Excel cannot complete the save.
- Check folder permissions:
- The save location must allow Read, Write, Modify, and Delete permissions.
- If saving to an external or network drive, a connection failure can also cause save errors.
- Test Excel in Safe Mode:
- Exit Excel.
- Open Excel while holding Ctrl until prompted.
- Select Yes to start in Safe Mode.
- Open a workbook and try saving again.
- If saving works in Safe Mode, a third-party add-in or startup file is likely causing the crash. Remove the add-in or startup file causing the issue.
- Temporarily disable antivirus scanning:
- Some antivirus software can interrupt Excel while it saves temporary files.
- Temporarily deactivate antivirus software, then test saving again.
- Shorten the file path if needed:
- If the full path and file name exceed 218 characters, Excel may show Filename is not valid.
- Move the file to a shorter path such as Desktop and try again.
- If the workbook still will not save, use one of these recovery workarounds:
- Move the worksheets to a new workbook:
- Press Shift+F11 to add a filler worksheet.
- Select the first real sheet, hold Shift, and select the last sheet.
- Right-click the grouped sheets and select Move or Copy.
- In To Book, select (New Book).
- Select OK and save the new workbook.
- Or save as a different file type:
- Go to File > Save As and choose another format such as .xlsx or .xlsm.
- Move the worksheets to a new workbook:
To reduce data loss going forward:
- Store files in OneDrive or SharePoint and use AutoSave.
- In Excel, go to File > Options > Save and make sure:
- Save AutoRecover information every x minutes is enabled.
- Keep the last autorecovered version if I close without saving is enabled.