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

Tracy King updated on Jun 25, 2019 to File Recovery | How-to Articles

Summary

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.

PAGE CONTENT:
How to fix Excel crashes when saving and restore crashed files
Bonus Tip. How to recover lost/deleted Excel file with free file recovery software

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 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:

C:\Users\username\AppData\Local\Microsoft\Office\UnsavedFiles

  • For Windows 7 users:

C:\Users\username\AppData\Roaming\Microsoft\Excel\ 

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 Freeware

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 use EaseUS free data recovery software to help you. 

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.

Simple steps for Excel file recovery are as follows:

Step 1. Specify a location

Run EaseUS Data Recovery Software, firstly, you're asked to choose a location to start. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else, and then click "Scan".

select the excel file location

Step 2. Scan 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.

scan excel files

Step 3. Preview and recover

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. Select the desired files and click "Recover".

select excel files and recover
 
 

100% of people found this article helful.

 

Frequently Asked Qusetions

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.