excel keeps crashing when i try to save a file the screen goes grey

Use the following steps to troubleshoot Excel crashing when saving and the screen going grey.

1. Test saving to a different location
   • Save the workbook to a local folder such as Desktop or Documents instead of a network drive, external drive, or synced folder.
   • If saving locally works, the issue may be with the network/storage location or connection.
2. Check disk space
   • Ensure there is enough free space on the drive where the file is being saved. If the disk is full, Excel cannot complete the save operation and may fail.
3. Check permissions on the folder
   • Make sure the account used has Read, Write, Modify, and Delete permissions on the folder where the file is being saved.
   • If only read access is available, Excel cannot complete its save process and may fail when trying to create or rename its temporary file.
4. Try saving with a shorter path and different name
   • Save the file with a simple name (for example, Test.xlsx) in a folder with a short path (for example, C:\Temp).
   • Very long paths (over 218 characters including file name) can cause save errors.
5. Disable third‑party add-ins by testing in Excel Safe Mode
   • Close Excel.
   • Start Excel in Safe Mode by holding Ctrl while starting Excel, then choose Yes when prompted to start in Safe Mode.
   • Open the workbook and try saving.
   • If saving works in Safe Mode, a third‑party add-in or startup file is likely causing the crash. Remove or disable add-ins one by one until the problem stops.
6. Check antivirus interference
   • Temporarily disable antivirus real‑time scanning and test saving the file.
   • Some antivirus products can lock Excel’s temporary save file and interrupt the save process, causing hangs or crashes.
7. Move the file and test in a “clean” environment
   • Copy the file to a local drive and test there.
   • If the file is opened from a network share, SharePoint, redirected Documents folder, or via Remote Desktop/Citrix, test locally to see if the environment is contributing to the crash.
8. Investigate file complexity and size
   • Large files with many formulas, shapes, styles, or defined names can stress memory and cause hangs.
   • If possible, test with a new simple workbook: create a new file, enter a few values, and save. If the new file saves fine, the issue may be specific to the original workbook’s contents.
9. Ensure Office and Windows are up to date
   • Install the latest updates for Microsoft 365/Office and Windows. Updates can replace out-of-date components that cause crashes.

If Excel continues to crash after these steps, collect details (where the file is stored, whether Safe Mode helps, whether antivirus is involved) and contact Microsoft Support for guided troubleshooting.

References:

• Troubleshoot why Excel doesn't save changes
• Excel not responding, hangs, freezes or stops working