Microsoft Excel是一个不可或缺的工具——如果它工作正常的话。如果您在Excel(Excel)中遇到文档未保存错误，则您的重要数据将面临风险。
该错误本身是不言自明的，但对其背后的原因进行故障排除可能很困难。值得庆幸的是，有多种解决方案可以帮助您解决此问题并保护您的辛勤工作。
Microsoft Excel中出现文档(Document)未保存错误(Saved Error)的原因是什么？
使用Microsoft Excel时，有多种因素可能会导致文档未保存错误。了解这些原因将帮助您更好地解决问题并增加解决问题的机会。
- 文件损坏：如果您的Excel数据以某种方式损坏，您将无法保存该文件。例如，
如果它被带有流氓宏的恶意软件感染，就会发生这种情况。(infected with malware)
- 临时问题：Excel中有时会出现(Excel)未知的(Unknown)临时故障，导致您无法保存文件。如果发生这种情况，更改文件名并再次保存文档可能会有所帮助，就像快速重新启动
Excel一样。(Excel)
- 文件(File)类型兼容性：另一个潜在原因是文件类型与您的Excel版本不兼容。以不同的格式（例如XLS(XLS)或XLSX ）保存文件可能会解决问题。
- 存储空间有限：如果您尝试将文件保存在可用存储空间不足的位置，则可能会导致错误。保存文件之前，请务必确保有足够的存储空间。
- 软件冲突：后台运行的冲突软件或加载项可能会干扰 Excel 保存文档的能力。
- 网络错误：如果您尝试保存到网络驱动器上的某个位置，但连接或保存位置出现问题，则文件将无法保存。
如果您遇到此错误，请尝试下面的一些常见修复方法来解决它。
重新启动 Excel
有时，只需(Simply)重新启动Excel即可解决(Excel)Excel中的文档未保存错误。在执行更复杂的故障排除方法之前，请尝试按照以下步骤快速重新启动
Excel ：
- 关闭计算机上
所有打开的Excel工作簿。(Excel)
- 等待(Wait)几秒钟以确保Excel已成功关闭。
- (Reopen Excel)通过快捷方式或“开始”菜单启动(Start)Excel 来重新打开它。
- 重新打开您的工作簿并尝试再次保存。
如果Excel未关闭，您需要打开任务管理器(open Task Manager)并强制终止 excel.exe 应用程序。
关闭其他打开的应用程序
同时运行多个应用程序可能会导致冲突并导致错误，例如Microsoft Excel(Microsoft Excel)中的文档未保存问题。当另一个应用程序（例如第三方备份工具）正在访问
您尝试保存在Excel中的文件时，尤其会发生这种情况。(Excel)
为此，请通过底部的任务栏关闭所有打开的应用程序。您还可以通过右键单击“(Task Manager)开始”(Start)菜单并选择“任务管理器”来打开“任务管理器”(Task Manager)，然后强制终止任何打开的应用程序。
请记住，关闭其他应用程序有助于释放系统资源，因此在使用(Remember)Excel时关闭不必要的程序始终是一个好主意。请务必经常保存您的工作，以避免在出现软件或硬件问题时丢失数据。
解决权限问题
权限问题可能是Microsoft Excel(Microsoft Excel)中文档未保存错误的常见原因。要解决这些问题，请按照以下步骤操作：
- 检查(Check)文件权限：如果您的帐户没有编辑文件的正确文件权限，您将无法保存该文件。您可以通过右键单击文件资源管理器(File Explorer)中的文件并选择属性，然后选择安全(Security)选项卡来检查这一点。在此处，请确保您拥有所需的读写访问权限，然后按“编辑”(Edit)继续操作。
- 在本地保存文件：如果您尝试将文件保存到网络位置，请先尝试将其保存到本地计算机。这可以帮助确定问题是否与网络权限或文件本身有关。
- 禁用只读模式：确保(Make)文件未设置为只读模式。您可以通过右键单击该文件，选择“属性”，然后取消选中“常规”(General)选项卡中的“只读”属性（如果已启用）来进行检查。
- 检查文件锁定：在某些情况下，其他用户可能打开了该文件，从而阻止您保存更改。在尝试再次保存之前，请确保该文件已在其他地方关闭。
检查您的网络连接
如果您要保存到网络驱动器或不直接位于电脑上的其他位置，并且连接不稳定或者您没有保存文件所需的访问权限，则在保存文件时可能会遇到问题。
首先，确认您的计算机已连接到网络，并且可以通过文件资源管理器(via File Explorer)访问相同的文件位置。如果您可以打开保存位置并与其他文件交互（例如重命名它们或保存它们），那么您的连接应该是稳定的，并且您应该能够继续。
但是，如果不这样做，则需要检查PC 上的连接是否正常工作。(check your connection is working properly)Windows 用户可能还需要考虑修复 Windows 安装(repairing their Windows installation)以解决任何系统问题。
使用新名称(New Name)和文件位置(File Location)保存Excel 文件(Excel File)
Microsoft Excel中的文档未保存错误通常可以通过使用新名称和文件位置保存打开的文件来解决。
- 为此，请打开有问题的Excel工作簿。
- Select File > Save从菜单中选择文件 > 另存为。
- 选择一个新位置来保存文件。这将确保位置本身不会成为问题。
- 接下来，为您的文件指定一个不同的名称。这将使您确定这是新文件。
- 按“保存”保存文件。
如果此过程修复了文档未保存错误，您可以继续处理工作簿，不会出现任何问题。
以安全模式启动 Excel
第三方Excel加载项和配置更改有时会导致出现问题。如果您想排除这种情况，则需要在安全模式下重新启动 Excel(restart Excel in Safe Mode)。安全模式(Mode)可以在加载文件之前禁用可能造成破坏的第三方加载项，从而帮助您解决问题。
要以安全模式(Safe Mode)启动Excel，请按照下列步骤操作：
- 右键单击(Right-click)“开始”(Start)菜单并选择“运行”(Run)。或者，同时按Windows + R键打开“运行”(Run)对话框。
- 在“运行”(Run)对话框中，键入 excel.exe /safe并按Enter。此命令将以安全模式(Safe Mode)启动Excel。
在安全模式(Safe Mode)下启动Excel后，检查文档未保存错误是否仍然存在。如果不是，则问题可能与导致冲突的第三方加载项有关。您需要禁用或管理加载项才能解决问题。
- 当Excel处于安全模式(Safe Mode)时，按“文件”(File) > “选项”(Options)。
- 在“选项”(Options)菜单中，选择“加载项”(Add-ins)。
- 从“管理(Manage)”下拉列表中，选择“Excel 加载项”(Excel Add-ins)并按“执行”。
- 在Excel 加载项(Excel Add-ins)窗口中，取消选中加载项旁边的框以禁用它们。您可以禁用所有这些以在没有加载项的情况下启动Excel（因此不会出现潜在冲突），或者逐一执行此操作以识别有问题的加载项。
- (Repeat)对COM 加载项(COM Add-ins)重复这些步骤以禁用它们。
- 单击“确定”(Click OK)，关闭Excel，然后重新启动Excel以开始正常使用。
修复或重新安装 Office
Office安装中的未知问题可能会导致Excel等应用程序出现问题。要解决此问题，您可以尝试修复Office安装或完全重新安装。
维修处
要修复Windows上的(Windows)Office安装，请按照下列步骤操作：
- 右键单击(Right-click)“开始”(Start)菜单并选择“设置”(Settings)。
- 在“设置”(Settings)中，选择Apps > Apps和功能”(Features)。
- 使用应用程序(App)列表搜索栏或手动滚动应用程序列表，直到找到Office安装并将鼠标悬停在其上。
- 按Office(Office)安装旁边的三点菜单图标，然后选择“高级选项”(Advanced Options)。
- 按照屏幕上的说明修复Office套件。
重新安装Office
如果修复Office套件无法解决问题，您可能需要完全重新安装Office。就是这样：
- 右键单击(Right-click)“开始”(Start)菜单并选择“设置”(Settings)。
- 在“设置”(Settings)中，选择“应用程序(Apps)和功能”(Features)。
- 滚动浏览(Scroll)应用程序列表或使用搜索栏查找Office安装，然后使用鼠标将鼠标悬停在其上。
- 按Office(Office)安装旁边的三点菜单图标，然后选择卸载(Uninstall)。
- 按照屏幕上的说明删除Office。
- 卸载过程完成后，运行本地Office安装程序文件或访问Microsoft Office 网站(Microsoft Office website)下载最新版本的Office。
重新安装Office(Office)后，尝试打开并保存 Excel 文档，查看文档未保存错误是否已解决。请记住(Remember)，重新安装Office可能会删除您之前所做的任何自定义设置更改，因此您之后需要再次重新配置它们。
修复Microsoft Excel中的文档(Document) 错误(Errors)
如果您在Excel(Excel)中看到文档未保存错误，上述步骤之一应该可以帮助您解决该情况。如果您仍然遇到问题（或者您的Excel 文件无法打开(Excel file just won’t open)），您可能需要考虑将 Excel 文件转换为 Google 表格(converting the Excel file to Google Sheets)以检索数据。
锁定了您的Excel文件？如果您想稍后对其进行编辑，请不要忘记接下来取消对 Excel 文件的保护(unprotect your Excel file)。
How to Fix Microsoft Excel “Document Not Saved” Error
Microsoft Excel іs an indispеnsable tool—if it’s working prоperly. If you encounter the documеnt not savеd error in Excel, you’re left in a situation where your important data is at risk.
The error itself is self-explanatory, but troubleshooting the cause behind it can be difficult. Thankfully, there are several solutions that can help you resolve this issue and protect your hard work.
What Causes a Document Not Saved Error in Microsoft Excel?
There are several factors that can contribute to the document not saved error when you’re using Microsoft Excel. Understanding these causes will help you better troubleshoot the issue and increase your chances of resolving it.
- File corruption: If your Excel data is corrupted in some way, you won’t be able to save the file. This can happen if it’s been infected with malware with a rogue macro, for instance.
- Temporary issues: Unknown, temporary glitches sometimes occur in Excel that prevent you from saving the file. If this happens, changing the filename and saving the document again might help, as can giving Excel a quick restart.
- File type compatibility: Another potential cause is the incompatibility of the file type with your version of Excel. Saving the file in a different format, like XLS or XLSX, might resolve the problem.
- Limited storage space: If you’re trying to save the file in a location with low available storage, it may lead to the error. Always ensure there’s sufficient storage space before saving the file.
- Software conflicts: Conflicting software or add-ins running in the background may interfere with Excel’s ability to save documents.
- Network errors: If you’re trying to save to a location on a network drive, but you have issues with the connection or save location, the file won’t save.
If you encounter this error, try some of the common fixes below to resolve it.
Restart Excel
Simply restarting Excel can sometimes resolve the document not saved error in Excel. Before you perform more complex troubleshooting methods, try giving Excel a quick restart by following these steps:
- Close all the open Excel workbooks on your computer.
- Wait for a few seconds to ensure that Excel has closed successfully.
- Reopen Excel by launching it via a shortcut or the Start menu.
- Reopen your workbook and try saving it again.
If Excel doesn’t close, you’ll need to open Task Manager and force the excel.exe application to terminate.
Close Other Open Applications
Having multiple applications running simultaneously can cause conflicts and lead to errors like the document not saved issue in Microsoft Excel. This can particularly occur when a file you’re trying to save in Excel is being accessed by another application (such as a third-party backup tool).
To do this, close any open applications via the taskbar at the bottom. You can also open Task Manager by right-clicking the Start menu and selecting Task Manager, then terminating any open applications by force.
Remember that closing other applications can help free up system resources, so it’s always a good idea to keep unnecessary programs closed while working in Excel. Always make sure to save your work frequently to avoid data loss in case of software or hardware issues.
Resolve Permission Issues
Permission issues can be a common cause for the document not saved error in Microsoft Excel. To address these issues, follow the steps below:
- Check file permissions: If your account doesn’t have the right file permissions to edit the file, you won’t be able to save it. You can check this by right-clicking on the file in File Explorer and selecting Properties, and then selecting the Security tab. From here, make sure you have the required read and write access before you proceed by pressing Edit.
- Save the file locally: If you’re trying to save the file to a network location, try saving it to your local machine first. This can help determine whether the issue is related to network permissions or the file itself.
- Disable Read-only mode: Make sure that the file is not set to read-only mode. You can check this by right-clicking on the file, selecting Properties, and unchecking the Read-only attribute in the General tab if it’s enabled.
- Check for file locks: In some cases, another user may have the file open, preventing you from saving changes. Ensure that the file is closed elsewhere before trying to save it again.
Check Your Network Connection
If you’re saving to a network drive or another location that isn’t directly on your PC, you may encounter problems saving your file if the connection isn’t stable or you don’t have the necessary access to save the file.
First, confirm that your computer is connected to the network and has access to the same file location by visiting it via File Explorer. If you can open the save location and interact with other files (such as renaming them or saving them), then your connection should be stable, and you should be able to continue.
If you don’t, however, you’ll need to check your connection is working properly on your PC. Windows users may also need to consider repairing their Windows installation to resolve any system issues, too.
Save the Excel File with a New Name and File Location
The document not saved error in Microsoft Excel can often be resolved by saving the open file with a new name and file location.
- To do this, open your problematic Excel workbook.
- Select File > Save As from the menu.
- Select a new location to save the file. This will ensure that the location itself isn’t a problem.
- Next, give your file a different name. This will allow you to determine that this is the new file.
- Press Save to save the file.
If this process fixes the document not saved error, you can continue to work on your workbook without any issues.
Start Excel in Safe Mode
Third-party Excel add-ins and configuration changes can sometimes cause problems to occur. If you want to rule this out, you’ll need to restart Excel in Safe Mode. Safe Mode helps you troubleshoot issues by disabling the potentially disruptive third-party add-ins before you load your file.
To start Excel in Safe Mode, follow these steps:
- Right-click the Start menu and select Run. Alternatively, press the Windows + R keys simultaneously to open the Run dialog box.
- In the Run dialog box, type excel.exe /safe and press Enter. This command will launch Excel in Safe Mode.
After launching Excel in Safe Mode, check if the document not saved error still persists. If it doesn’t, the issue might be related to a third-party add-in causing conflicts. You’ll need to disable or manage the add-ins to resolve the issue.
- With Excel in Safe Mode, press File > Options.
- In the Options menu, select Add-ins.
- From the Manage drop-down list, select Excel Add-ins and press Go.
- In the Excel Add-ins window, uncheck the boxes next to add-ins to disable them. You can disable all of them to start Excel with no add-ins (and thus no potential conflicts) or do it one by one to identify the problematic add-in.
- Repeat these steps for COM Add-ins to disable those, too.
- Click OK, close Excel, and restart Excel to begin using it normally.
Repair or Reinstall Office
Unknown issues within your Office installation can cause problems with applications like Excel. To fix this, you can try repairing your Office installation or reinstalling it completely.
Repair Office
To repair your Office installation on Windows, follow these steps:
- Right-click the Start menu and select Settings.
- In Settings, select Apps > Apps and Features.
- Use the App list search bar or scroll through the list of applications manually until you find your Office installation and hover over it.
- Press the three-dot menu icon next to the Office installation and select Advanced Options.
- Follow the on-screen instructions to repair the Office suite.
Reinstall Office
If repairing the Office suite doesn’t solve the issue, you may need to reinstall Office entirely. Here’s how:
- Right-click the Start menu and select Settings.
- In Settings, select Apps and Features.
- Scroll through the list of applications or use the search bar to find the Office installation, then hover over it using your mouse.
- Press the three-dot menu icon next to the Office installation and select Uninstall.
- Follow the on-screen instructions to remove Office.
- Once the uninstall process is complete, run your local Office installer file or visit the Microsoft Office website to download the latest version of Office.
After reinstalling Office, try opening and saving your Excel documents to see if the document not saved error is resolved. Remember that reinstalling Office might remove any custom settings changes you’ve previously made, so you’ll need to reconfigure them again afterward.
Fixing Document Errors in Microsoft Excel
If you’re seeing the document not saved error in Excel, one of the steps above should help you to resolve the situation. If you’re still having trouble (or if your Excel file just won’t open), you might want to consider converting the Excel file to Google Sheets to retrieve your data.
Locked down your Excel file? If you want to edit it afterward, don’t forget to unprotect your Excel file next.
