自动保存(AutoSave)功能是Office程序中最好的功能之一,可让您自动保存数据。如果您忘记保存数据,您可以避免丢失数据。但是,如果AutoSave停止工作怎么办?这可能是由于Excel工作簿、Word文档或PPT损坏、禁用自动保存、 (AutoSave)Excel安装问题等不同原因而发生的。
如果您在Excel、Word或PowerPoint中遇到(PowerPoint)自动保存(AutoSave)功能停止工作的相同问题,本文将帮助您解决问题。
自动保存(AutoSave)在Excel、Word或PowerPoint中不起作用(PowerPoint)
如果自动保存功能在(Auto Save)Excel、Word或PowerPoint等(PowerPoint)Microsoft Office程序中不起作用,以下是修复方法。虽然我们可能在这里讨论过Excel ,但(Excel)其他 Office 程序(other Office programs)的过程也是相同的。
- 确保启用自动保存(AutoSave)功能
- 不支持旧格式
- 修复损坏的文件
- 重新保存 Office Temp 文件
- 修复/重新安装 Office。
1]检查(Check)是否启用了自动保存(AutoSave)功能
您应该检查的第一件事是Excel中没有禁用(Excel)AutoSave功能。如果它被禁用,您的Excel文件和数据将不会自动保存。
您可以从工具栏顶部启用它。在那里,您将看到一个自动保存(AutoSave)按钮,您必须打开该按钮以确保将数据自动保存到您的 OneDrive 帐户。
或者,您也可以转到“ File > Options”菜单,然后从“保存( Save)”选项卡中启用“自动保存(AutoSave)”和其他相关配置。
您还需要启用每隔指定分钟保存自动恢复信息(Save AutoRecover information every specified minute)并输入自动恢复间隔。另外,如果我关闭而不保存框选项,请勾选保留最后一个自动恢复的版本。(Keep the last AutoRecovered version if I close without saving box )
如果这不能解决问题,请尝试其他方法来解决问题。
2] 不支持旧格式
您应该知道,旧文件格式(如.xls、.doc或 .ppt )不支持自动保存功能。(AutoSave)在这种情况下,您可以更改文件扩展名并查看是否有帮助。
3]修复损坏的文件
您的Excel文件可能已损坏,因此自动保存(AutoSave)功能无法正常工作。因此,修复损坏的 Excel 文件(repair the corrupted Excel file)。您可以使用 Excel 的内置修复功能来做到这一点。以下是执行此操作的步骤:
- 启动 Excel 并转到 File > Open选项并选择要修复的文件。
- 单击(Click)打开下拉按钮,然后点击打开和修复(Open and Repair)选项。
- Excel现在将提示您两个选项,包括Repair和Extract。您可以使用修复(Repair)选项来修复损坏的Excel工作簿。如果修复(Repair)功能不起作用,您可以使用提取(Extract)功能从工作表中提取值和公式。
之后,检查这是否有助于修复Excel中的(Excel)AutoSave not working 问题。
4]重新保存临时文件
如果自动保存功能在(AutoSave)Excel中不起作用,您可以从临时文件中恢复您的Excel文件。这些文件通常位于Windows 10中的以下位置:
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\
您将在此处看到类似的Word和PowerPoint文件夹;
C:\Users\<username>\AppData\Roaming\Microsoft\
您还可以尝试在其他位置查找未保存的Excel文件:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
当您找到Excel临时文件时,使用XLS或XLSX扩展名重新保存它以恢复工作簿。
5]修复或重新安装Office
如果修复此错误似乎没有任何效果,您可以重新安装或修复Excel、Word或PowerPoint。缺少组件也可能导致AutoSave无法正常工作错误。因此(Hence),您修复Excel程序或选择重新安装它。
要修复,您可以转到“Settings > Apps部分,选择Microsoft Office模块,然后单击“更改”( Change)选项。它将要求您使用快速修复(Quick Repair)和在线修复(Online Repair)两种方法修复程序。选择两个选项之一,然后单击“修复(Repair)”按钮开始修复Office。
您也可以卸载然后重新安装Microsoft Office,然后检查自动保存(AutoSave)功能不工作的问题是否仍然存在。
希望这里的东西对你有所帮助。
AutoSave not working in Excel, Word or PowerPoint
AutoSave feature is one of the best features in Office programs that enables you to save your data automatically. You can avoid losing your data in case you forgot to save it. But, what if AutoSave stops working? This can happen due to different reasons like the Excel workbook, Word document or PPT is damaged, the AutoSave is disabled, problems with Excel installation, etc.
If you are experiencing the same problem where the AutoSave feature has stopped working in Excel, Word or PowerPoint, this article will help you to resolve the issue.
AutoSave not working in Excel, Word or PowerPoint
Here are the methods to fix if the Auto Save feature is not working in Microsoft Office programs like Excel, Word or PowerPoint. While we may have talked about Excel here, the procedure is the same for other Office programs too.
- Ensure that the AutoSave feature is enabled
- Older formats not supported
- Fix corrupted file
- Resave Office Temp files
- Repair/Reinstall Office.
1] Check if the AutoSave feature is enabled
The first thing you should check is that the AutoSave feature is not disabled in Excel. If it is disabled, your Excel files and data won’t be saved automatically.
You can enable it from the top of the toolbar. There you will see an AutoSave button that you have to turn on to make sure to save data automatically to your OneDrive account.
Alternately, you can also go to the File > Options menu, and from the Save tab, enable AutoSave and other related configurations.
You also need to enable Save AutoRecover information every specified minute and enter the auto recover interval. Plus, tick on the Keep the last AutoRecovered version if I close without saving box option too.
If this doesn’t fix the problem, try another method to resolve the issue.
2] Older formats not supported
You should know that the AutoSave feature is not supported in older file formats like .xls, .doc, or .ppt. In this case, you may change the file extension and see if it helps.
3] Fix corrupted file
Your Excel file might be corrupted and thus AutoSave function is not working. So, repair the corrupted Excel file. You can do so by using Excel’s inbuilt repair feature. Here are the steps for that:
- Launch Excel and go to File > Open option and select the file that you want to fix.
- Click on the Open drop-down button and then tap on the Open and Repair option.
- Excel will now prompt you two options including Repair and Extract. You can use the Repair option to fix the corrupted Excel workbook. In case if Repair function doesn’t work, you can use the Extract feature to extract values and formulas from the sheet.
After that, check if this helps in fixing the AutoSave not working issue in Excel.
4] Resave Temp files
If the AutoSave feature is not working in Excel, you can recover your Excel files from temp files. These files are generally present at the following location in Windows 10:
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\
You will see similar folders for Word and PowerPoint here;
C:\Users\<username>\AppData\Roaming\Microsoft\
You can also try looking for unsaved Excel files at another location which is:
C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
When you find the Excel temp file, resave it with XLS or XLSX extension to recover the workbook.
5] Repair or Reinstall Office
If nothing seems to work in fixing this error, you can reinstall or repair Excel, Word or PowerPoint. A missing component can also cause AutoSave not working error. Hence, you repair the Excel program or choose to reinstall it.
To repair, you can go to the Settings > Apps section, choose the Microsoft Office module, and then click on the Change option. It will ask you to repair the program using two methods which are Quick Repair and Online Repair. Choose one of the two options and click on the Repair button to start repairing Office.
You can also uninstall and then reinstall Microsoft Office and then check whether the AutoSave feature not working problem is still there.
Hope something here helped you.