8 Ways to Fix Excel AutoSave Not Working
First, check if the Autosave option is enabled
4 min. read
Updated on
Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more
Many users have reported that AutoSave is not working on Microsoft Office programs like Excel, PowerPoint, and Word. The reasons for this issue could be corrupted files, conflicting add-ins, or a damaged Office app.
First, check the file in question to ensure it doesn’t have older file formats such as .xls, .doc, or .ppt, then proceed to detailed solutions.
How can I fix AutoSave not working in Excel?
1. Check if the AutoSave feature is enabled
- Press the Windows key, type excel in the search bar, and click Open.
- Go to File.
- Click Options.
- Click the Save section from the left pane on the Excel Options window.
- Locate the Save AutoRecover information everyโminute option, select it, and mention the time in minutes in the blank.
- Locate and place a checkmark next to Keep the last AutoRecovered version if I close without saving box option.
- You can also place a checkmark next to the AutoSave files stored in the Cloud by default in Excel.
- Click OK to save the changes.
2. Use the Open and Repair option
- On Excel, go to File, click Open, and then Browse.
- From the following window, choose the file you have issues with.
- Select the Open and Repair option from the Open drop-down menu and press Enter.
- You will get a prompt with two options: Extract Data and Repair. Use Repair if you want to fix the corrupt Excel workbook. However, you can choose Extract Data to extract formulas and values from the sheet.
3. Resave the temp files
- Press Windows + E to open the File Explorer window.
- Navigate to this path after replacing <username> with the username of your account on your device :
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\
- If you can’t find the unsaved files there, go to this path:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
- If you locate the Excel temp file, press F2 and rename it with an XLS file format to recover the Workbook.
4. Update the Excel app
- Press the Windows key, type excel in the search bar, and click Open.
- Go to File.
- Click Account.
- From the right pane, click Update options, and from the drop-down, click Update Now.
5. Disable the Add-ins
- Press the Windows key, type excel in the search bar, and click Open.
- Go to File.
- Click Options.
- Now select Addins.
- Locate Manage, choose Excel Add-ins from the drop-down, and click Go.
- Remove the checkmark next to all the Add-ins listed and click OK.
Conflicting add-ins can also cause issues like Excel files not opening on Windows 11; however, there could be other reasons too, here is a detailed guide for you.
6. Remove security features
- Press the Windows key, type excel in the search bar, and click Open.
- Go to File.
- Select Info.
- Click Protect Workbook, then select Encrypt with Password from the drop-down menu.
- In the following window, remove password protection and save the changes.
- Again, navigate to File > Info > Protect Workbook> Restrict Access and select Unrestricted Access.
7. Refresh data when opening the file (applicable if you have Table/Pivot Table in a file)
- Choose the table or Pivot table and go to Table Tools Design.
- Click Refresh and select Connection Properties from the context menu.
- Now, remove the checkmark next to Refresh data when opening the file.
8. Repair/reinstall the Microsoft Office
- Press Windows + I to open the Windows Settings app.
- Go to Apps, then click Installed apps.
- Locate Microsoft Office, click the three-dot icon, and select Modify.
- Click Yes on the UAC prompt.
- From the pop-up window, select Quick Repair and then click the Repair button to initiate the process.
- If this doesn’t help, you can reopen the Installed apps list, locate Microsoft Office, click the three-dot icon, and choose Uninstall.
- Click Uninstall again.
- Visit Microsoft’s official website and sign in.
- Go to Services and subscriptions, locate Microsoft Office, and click Install to get the latest app version.
- Once the installer is downloaded, double-click it and follow the on-screen instructions to complete the installation.
Reinstalling Microsoft Office can also fix other Office apps like Microsoft Excel not opening; check out this guide for other solutions.
This is how you can fix the AutoSave not working in Microsoft Excel issue; however, if you are dealing with corrupted files in Excel, we have a separate guide for you. You can also locate your autosave Excel files if you were not able to save them for some reason.
Moreover, you can learn how to enable macros to automate tasks.
If you have any questions or suggestions about the Excel AutoSave not working issue, feel free to mention them in the comments section below.
User forum
0 messages