Fix Excel Crashes When Saving Error Effectively

Tracy King updated on Sep 16, 2020 to File Recovery | How-to Articles

Summary

Don't worry if the Excel 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.

iso recovery

If the reason for Excel crashes when saving is because the program itself has a problem, running the repair tool will fix it. Step 1: Navigate to the Control Panel and click on "Programs and Features". Step 2: All of the programs that are installed on your computer will now be listed...

Check all the methods outlined in the following table.

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 with Open and Repair On the "File" tab, click "Open".Click on the location where the spreadsheet is loaded and click "Browse"...Full steps
Fix 3. Disable add-ins in Safe Mode Run Excel in safe mode to see if it can be accessed successfully. You can also try to disable add-ins...Full steps
How to recover unsaved Excel files If Excel crashes when saving makes you lose Excel files unsaved, restore Excel by AutoRecover...Full steps
How to recover deleted Excel files To recover deleted or lost Excel files, let EaseUS file recovery help you easily. You can recover Excel...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 the lost Excel files 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 Files 2016/2013/2010

If Excel 2016, 2013, 2010, or 2007 suddenly crashes on your PC while saving a file, don't worry, you can find all the effective methods in this article to fix the issue. You can follow any one of the offered ways to resolve Excel keeps crashing when saving. 

Don't miss: Word keeps crashing when saving, how to fix

Method 1. Repair Installation of Office/Excel to Fix Excel Crashes When Saving

Step 1. Reboot your Windows PC, right-click on the 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. Solve Excel Closes When Saving with 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 Excel when an attempt to repair the Excel is not successful.

excel crashes when saving

Method 3. Open the Excel File in Safe Mode and Disable Add-ins

If Excel cannot open the file, try running Excel in safe mode to see if it can be accessed successfully. This method also checks if there are any errors in MS Excel.

Step 1. Press Windows+R key, type excel.exe /safe, and click "OK". Loading Excel without templates and add-ins allows you to see if the program works as it should or if it is corrupted.

Open Excel in Safe Mode.

Step 2. If Excel opens normally, check for any add-ins that are causing problems in Excel. Disable the add-ins and click on the "OK" button.

Step 3. Restart Excel to check if the problem is fixed. If not, move on to the next approach.

How to Recover Unsaved Excel due to Excel Crashing When Saving

The three most effective ways above can solve the Excel crashing when saving problem. For further restoring of unsaved Excel files, you can make it by using the AutoRecover feature of Excel, or recovering from temp files or previous versions.

Also see: How to recover unsaved or lost Word document in Windows 10 

Method 1. Restore Crashed Excel Files from AutoRecover

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 pop-up 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 2. Retrieve 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 in which the program crashes, then copy and save it as a new file.

excel crashes when saving

Method 3. Retrieve Unsaved 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.

For how to recover unsaved Excel file Mac, here is the quick access. 

Bonus Tip. How to Recover Lost/Deleted Excel File with Data Recovery Software

By this point, we are sure you already know how to resolve Excel keeps crashing when saving. In this section, you will learn how to recover deleted, lost, or formatted Excel documents with EaseUS Data Recovery Wizard, the world-famous data recovery software. 

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.

Now, download EaseUS file recovery program to restore lost Excel files in three steps.

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

Conclusion

That is all there is to it. You can deal with Excel crashes when saving by using the Open and Repair function and repairing the installation of Excel. If your Excel is lost unsaved, you can recover unsaved Excel files caused by Excel crashing when saving from AutoRecover, Temp file, and previous versions.

EaseUS data recovery software gives you the greatest support to recover deleted or lost Excel or other files under any complex circumstances. In addition, it's also competent to repair corrupted Excel files, as well as photos, videos, and other documents.

FAQs About Excel Crashes When Saving

The following topics and questions are highly related to Excel crashes when saving issue. Check the brief answers to these problems. 

Why is Excel crashing when I save? 

The reason for Excel crashes when saving may be various, including:

  • Excel application crashes or has a problem
  • Third-party add-ins conflicts in Word program
  • Malware or virus infection

How do I stop Excel from crashing?

To fix Excel crashing when saving, try the tips below:

  • Run the Office Repair tool
  • Run and open Excel in Safe Mode
  • Disable COM add-ins
  • Uninstall and reinstall Office
  • Install Latest Update

Why does Word crash when I try to save?

Possible causes of Word crashes when saving:

  • MS Office settings or installation problem
  • Third-party add-ins in Word program
  • Software conflicts while editing any document in Word
  • Malware or virus attack
  • Improper operation of Excel 

Was This Page 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.