Fix 'Excel Crashes on Saving as A File' Error with 5 Methods

Tracy King updated on Feb 22, 2020 to File Recovery | How-to Articles


Don't worry if the Excel file crashes when saving as a file on Windows PC. This article will offer you 5 methods to help you effectively fix and repair ‘Excel crashes on saving as a file’ error in Windows 10/8/7 and help you restore all lost Excel file with ease.

Workable Solutions Step-by-step Troubleshooting
Fix 1. Repair Excel installation  Open "Control Panel" > click "Programs and Features" > find "Microsoft Office"> right-click on "Change"....Full steps
Fix 2. Restore crashed Excel On the "File" tab, click "Open".Click on the location where the spreadsheet is loaded and click "Browse"...Full steps
Fix 3. Restore from AutoRecover Open a new Excel. Click "File" > "Open" > "Recent" option. Check the recently used Excel document...Full steps
Fix 4. Retrieve from Temp file  Find the crashed or unsaved/lost Excel document. Check and select the temporary unsaved Excel file...Full steps
Fix 5. Restore from previous version Create a new Excel file and name it with the same file name of the crashed Excel document...Full steps

Excel crashes when saving files, what to do?

"I got a problem that the Excel suddenly crashed when I was trying to save it in Windows 10 last night. All my hard works and saved data on the Excel file were all gone. Now, I need a reliable way to get lost Excel file back and restore all data. How to do it? Does anyone know how to fix Excel crashes when saving in Windows 10?"

How to Fix Excel Crashes When Saving and Restore Crashed Files

If Excel 2016, 2013, 2010, or 2007 suddenly crashes on your PC while saving a file, don't worry, you can find five effective methods in this article to fix the issue. You can follow any one of the offered ways to restore crashed Excel file. For how to recover unsaved Excel file Mac, here is the quick access. 

Method 1. Repair Installation of Office/Excel to Restore Crashed Excel File in Windows 

Step 1. Reboot your Windows PC, right-click on Windows Start button, then select "Control Panel".

Step 2. Click "Programs and Features", then find and click "Microsoft Office".

Step 3. Right-click on "Change", a repair options dialog will appear.

Step 4. Select "Quick Repair" and open Excel to see whether problems got fixed.

Step 5. If not, select "Online Repair" and wait for the repair process to complete. After this, you can open the crashed Excel file, and it shall work by then.

excel crashes when saving

Method 2. Restore Crashed Excel by Open and Repair

Step 1. On the "File" tab, click "Open".

Step 2. In Excel 2016 or Excel 2013, click on the location where the spreadsheet is loaded and click "Browse".

Step 3. In "Open" dialog, select the corrupted or crashed Excel file that you want to open.

Step 4. Click the arrow next to the Open button and then click "Open and Repair".

Step 5. On the pop-up window, click "Repair" if you want to recover as much of Excel data as possible, or click "Extract Data" to extract values and formulas from the Excel when an attempt to repair the Excel is not successful.

excel crashes when saving

Method 3. Restore Crashed Excel from AutoRecover

If you've turned on the AutoRecover feature in Excel, you can then restore a crashed Excel file or spreadsheet from AutoRecover in your PC. This feature also works for recover unsaved Word document in Windows 10

Step 1. Open a new Excel file in Windows 10 or Windows 8/7.

Step 2. Click "File" > "Open" > "Recent" option.

Step 3. Then check the recently used Excel document and find the unsaved file when Excel crashes.

Restore crashed Excel file.

Step 4. Click "Recover Unsaved Workbooks" and wait to let the program recover your crashed Excel document.

Restore cashed Excel from AutoRecovery.

Step 5. Then a popup will occur, and you can open the crashed Excel file and click "Save AS" to store the Excel as a new file to a safe location on your PC.

Restore and save crashed Excel file.

Method 4. Retrieve Lost/Crashed Excel from Temp File 

You may also find the lost unsaved Excel file from the Temporary file folder when Excel crashes.

Step 1. Follow the temporary file folder location on your PC and find the crashed or unsaved/lost Excel document.

  • For Windows 10/8 users:


  • For Windows 7 users:


Step 2. Check and select the temporary unsaved Excel file which the program crashes, then copy and save it as a new file.

excel crashes when saving

Method 5. Retrieve Crashed Excel from the Previous Version

Step 1. Create a new Excel file and name it with the same file name of the crashed Excel document.

Step 2. Right-click on the Excel and select "Properties".

Step 3. Go to "Previous Versions", find and select the latest version before Excel crashes, click "Restore". Then you'll get the crashed Excel file back.

Bonus Tip. How to Restore Lost/Deleted/Formatted Excel File with File Recovery Software

The above five solutions are to recover unsaved and crashed Excel file but don't work for recovering deleted, lost, or formatted Excel documents. If you need to restore mistakenly removed Excel file, you can turn to EaseUS data recovery software for help. 

With this capable data recovery tool, you can easily do the following things.

  • Recover lost or deleted documents, photos, audio, music, emails, or other 200+ files from any storage device effectively.
  • Supports data recovery from SSD, HDD, emptied recycle bin, USB flash drive, Pen drive, external hard drive, CF/SD card, digital camera, and camcorders.
  • Supports to recover lost data due to mistaken deletion, formatting, hard drive corruption, virus attack, system crash, or other complex situations.

Step 1. Specify a location.

Run EaseUS Data Recovery Software. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".

select a location and click scan

Step 2. Scan for data.

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed. To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. 

scan excel files

Step 3. Preview and recover.

You can double click on a file to preview its integrity. Finally, select the desired files and click "Recover".

preview and recover excel files

100% of people found this article helpful.


Frequently Asked Questions

1. Why choose EaseUS Data Recovery Wizard?

"EaseUS Data Recovery Wizard is the best we've seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past, but it's fast and efficient..."PCMag

"The first thing you'll notice about EaseUS Data Recovery Wizard Pro is that its interface is very clear and uncluttered, with only a small collection of self-explanatory controls. You won't find lots of extra options hidden in a system of hidden menus, either; what you see really is what you get."techradar

"Recover lost files, even after deleting a partition or formatting your drive."Macworld

2. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

3. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

4. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

5. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files to better verify the recovery quality of our product before purchase.

6. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.