What Are Effective Ways to Solve Excel 2016 Not Saving Changes

Why is Excel not saving changes? Learn how to fix Excel 2016 not saving formatting changes on existing. You can solve Excel not saving changes issue by repairing corrupted Excel files with a file repair tool, starting Excel in safe mode, changing ownership, repairing Office installation, etc.

Table of Contents

You add new data, formulas, and formatting on your worksheet, then hit File and Save As to keep the changes. But when you bring up the file later to find that your changes are gone and not saved. What an annoying thing it is!

Sometimes, you may face the problem that Microsoft Excel not saving changes or Excel not saving formatting changes on existing. Although Excel has an AutoSave (how to turn on Excel AutoSave) function that will automatically store your workbook as you edit it, it doesn't work in this case where you've saved the files on one's own initiative.

The reasons behind Excel not saving changes problem are diverse. Read on and know why is Excel not saving formatting, and how to troubleshoot.

Why Is Excel Not Saving Changes (Formatting, Data, and Formula)

Do you have any idea why Excel 2016 not saving changes? The following information can help you identify possible causes of this issue.

  • Lack of permission to the folder where the file is saved.
  • Third-party Add-ins are interfering with Excel saving.
  • Excel XLS or XLSX file is corrupted due to uncertain factors.
  • Insufficient disk space for saving Excel changes.
  • Antivirus software conflicts with Excel and prevents saving changes.

Now that you've understood the causes of the Excel not saving changes problem, let's begin to address it.

Fix 1. Repair Corrupted Excel XLS or XLSX File

At the very beginning of problem-solving, you should first check whether your workbook is intact. If the Excel document workbook is damaged, of course, it cannot save the changes.

To repair corrupted Excel documents, you have two ways to make it.

Use a File Repair Tool

To repair damaged Excel, Word, or PTT Office documents, you can apply EaseUS Data Recovery Wizard for help. It supports repairing corrupted PDF, photos, and videos efficiently.

Step 1. Select a location to start finding corrupted Excel files

Launch EaseUS Data Recovery Wizard, and then scan the corrupted or damaged Excel files.

repair Excel file - 1

Step 2.  Scan for the corrupted Excel document

Find the damaged files through the filter, file path, search, etc.

repair damaged Excel files

Step 3.  Repair and save the Excel file to a secure location

Double-click the corrupt excel file, and this program will automatically repair corrupted and damaged Excel files. Click "Recover" to save the repaired Excel files to a safe location.

Save repaired Excel files

Use Office Open or Repair Option

Microsoft Office offers an inbuilt Open or Repair tool to fix corrupted documents.

Step 1. Start Excel 2016, 2013, 2010, or other versions.

Step 2. Click "File" at the top left corner, then, click "Open".

Step 3. In the Open dialog box, choose the Excel file that cannot be saved.

Step 4. Click the down arrow on the "Open" button, and then click "Open and Repair".

repair corrupted Excel files

Fix 2. Check the Folder Permission

When you want to save an Excel file, you need to have the read, write, and modify permissions to the folder in which you are going to save the workbook.

You can right-click the folder, choose "Properties" > click the "Security" tab. Check the permission for the folder.

check folder permission

If the read and write permission are denied, the Excel saving process can't be completed. And you need to take the ownership to edit and save the file.

Fix 3. Start Excel in Safe Mode

Sometimes, plug-ins are the source of the problem. If you can save Excel formatting when you run Excel in safe mode, the problem may be caused by a third-party add-in.

Start your application in safe mode and see if Excel not saving changes problem has gone away.

Hold the Ctrl key and click on the Excel icon. Don't release the Ctrl key till it asks you for safe mode confirmation. Click "Yes" to open Excel in safe mode.

run excel safe mode

If you can save Excel formatting changes, then open Excel normally and disable add-ins one by one and run it start again every time you disable an add-in to determine the culprit add-in.

Fix 4. Disable Add-ins in Excel

Step 1. Open Excel. Click "File" > "Options" > "Add-ins".

Step 2. Select "COM Add-ins", and click "Go".

Step 3. Uncheck all the add-ins in the list, and click "OK". Then restart Excel.

disable add-ins in excel

Fix 5. Make Sure Enough Space on Disk

When you save Excel to a hard disk or an external storage drive, you must make sure that the disk has sufficient free space to allow you to save the file. If the hard disk does not have sufficient space, Excel cannot complete the save operation, and you receive Excel not saving changes error message.

You can use an easy Windows 10 partition management tool to help you resize and extend the partition. EaseUS Partition Master allows you to extend the partition on HDD, SSD, and external hard drive without data loss.

Simple steps to increase space on a hard drive partition with EaseUS partitioning software.

Step 1. Locate the Target Partition

To start extending partition, you should first locate the target partition and select "Resize/Move".

Select target partition to extend

Step 2. Extend the Target Partition

Drag the partition panel rightward or leftward to add unallocated space into your current partition and click "OK" to confirm.

choose another drive to allocate space

Extra Option: Get Space from Another Drive

If there is not enough unallocated space on your disk, right-click on a big partition with enough free space, select "Allocate space ".

Then select the target partition that you want to extend at the allocate space to column.

choose another drive to allocate space

Step 3. Execute Operations to Extend Partition.

Drag the dots of the target partition into the unallocated space and click "OK".

finish extending partition

Then Click the "Execute Operation" button and click "Apply" to keep all the changes. 

Fix 6. Repairing Office Installation

Microsoft has a repair utility to repair corrupted Office applications that may cause Excel not saving changes.

You can first try Quick Repair that takes a few mins. If that doesn't help then try Online Repair to fix corrupted installation that may take dozens of minutes in general.

Step 1. Right-click the Windows start button, and click "Control Panel".

Step 2. Click "Programs and Features" and click on "Microsoft Office".

Step 3. Click "Repair" > "Continue". Choose "Quick Repair" or "Online Repair". Wait for the process to finish and start Excel and see if you can save it

repair office installation

Fix 7. Deactivate the Antivirus Software Temporarily

When the antivirus software is running and protecting your computer, it may interrupt the Excel saving process and stop you from keeping formatting or data changes.  

To check whether your antivirus software conflicts with Excel, you can temporarily close the antivirus software, and then try to save the Excel file. However, Microsoft does not recommend that users turn off anti-virus software, because it makes your computer vulnerable to viruses or malware. Therefore, once the problem is figured out, you need to open the anti-virus software in time.  

Other Useful Workarounds to Save Excel Workbooks

If none of the solutions that are listed in this article helps to solve the Excel not saving changes, or Excel not saving formatting changes problem, try the following options to save your Excel files.

  • Use the Save AS feature to save the Excel by using a new file name.
  • Move the original worksheets to a new workbook.
  • Save the file as a different Excel file type, such as change .xls to .xlsx or convert .xlsx to .xls.
  • Save the workbook to a different location.
  • Try to save the Excel files in safe mode.

To Sum Up

That's it. We have tried out best to cover all the useful information about Excel 2016 or other Excel versions not saving changes issue. The reasons for this problem are restricted file permission, third-party Add-ins, not enough storage space, file damage, and conflicting antivirus software.

To solve Excel cannot save matter, you can take corresponding measures to solve Excel not saving changes. For example, check folder permission, disable add-ins, extend the disk space, turn off antivirus software, as well as repair corrupted Excel files with a file repair tool.

If the methods don't work, and your Excel still not saving formatting changes, take the several tips to save Excel files in other ways.

Hope this user guide can help you.

Was This Page Helpful?

Updated by Cedric

Cedric Grantham is one of the senior editors of EaseUS who lives and works in Chengdu, China. He mainly writes articles about data recovery tutorials on PC and Mac and how-to tips for partition management. He always keeps an eye on new releases and likes various electronic products.

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.

    Read More
  • 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.

    Read More
  • EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.

    Read More