如果您收到消息“Microsoft Excel 无法访问该文件”，则表示文件路径出现问题。这是一个令人沮丧的错误，它可能会阻止您打开重要文档。
在本文中，我们将解释如何修复“Microsoft Excel 无法访问文件”错误并重新获得对工作簿的访问权限。
导致错误的原因是什么？
您可能会收到此Excel(Excel)错误的三个主要原因：
- 文件名或路径不存在。
- 该文件正在被另一个程序使用。
- 您尝试保存的工作簿与当前打开的工作簿同名。”
下面，我们将从最有可能解决此错误的修复开始。因此，从修复 1(Fix 1)开始，逐步解决，直到问题消失。
修复 1：确保外部(Valid)链接(External Links)有效
由于尝试单击外部工作簿或工作表的链接时经常会发生此错误，因此第一步是确保这些链接正确。对于Excel电子表格中的每个链接：
- 确保(Make)链接的工作簿尚未移动或重命名。这将影响文件路径，并且Excel将无法找到链接的项目。
- (Delete linked items)如果您找不到
链接的项目，请将其删除。
要查找所有外部链接：
- 打开 Excel 应用程序。
- Press Ctrl + F搜索工作簿。
- 选择选项。
- 输入“.xlsx”并按“查找内容”。
- 在“内部”下，选择“工作簿”(Workbook)，然后在“查找(Look)范围”下，选择“公式”(Formulas)。
- 选择查找全部。
修复 2：更新 Microsoft Excel
软件(Software)更新通常可以解决临时问题。为了确保此故障不是由过时的Excel程序引起的，您应该将其更新到最新版本。为此：
- 打开 Excel。
- 选择“文件”>“帐户”。
- 选择更新(Update) 选项(Options)>立即更新(Update)。
修复 3：禁用 Excel 加载项
有时，加载项可能会导致Excel工作表出现问题。为了确保它们不会导致“无法访问文件”故障，请禁用所有加载项并一一重新启用它们。为此：
- 打开 Excel 工作簿。
- 选择“文件”>“选项”。
- 选择加载项。
- 取消选中所有框并单击“确定”。
- 逐一启用每个加载项，直到故障再次出现。
修复 4：缩短文件路径长度(File Path Length)
此故障可能是由文件路径太长引起的。为了确保不是这种情况，请将Excel文件移动到父文件夹（而不是一系列子文件夹）并将其重命名为较短的名称。文件路径缩短后，更新Excel工作簿中的链接并尝试打开该文件。
修复 5：将Excel 文件(Excel File)移动到桌面(Desktop)
一些用户注意到，如果Excel文件位于桌面(Desktop)文件夹而不是计算机文件系统的其他位置，则此错误就会消失。虽然这不是一个很好的修复方法，但它可以暂时消除故障，以恢复Excel电子表格的正常功能。
注意：当文件存储在网络驱动器而不是本地驱动器中时，也会出现此错误。确保(Make)文件保存在 C:\Users\用户名\桌面。
修复 6：清除Office 文档缓存(Office Document Cache)
清除Office文档缓存也可以解决此错误。为此：
- 打开Windows 资源管理器(Windows Explorer)并前往Office 文件缓存(Office File Cache)。对于Office 2016，可以在“%localappdata%\Microsoft\Office\16.0\OfficeFileCache”中找到。对于Office 2013，可以在“%localappdata%\Microsoft\Office\15.0\OfficeFileCache”中找到。欧元
- 选择(Select)所有以“FS”开头的文件并将其删除。
- 重新启动Excel文档并查看错误是否仍然存在。
修复 7：关闭所有其他程序
此Microsoft Office Excel(Microsoft Office Excel)故障的原因之一是另一个程序当前正在使用该Excel文件，因此无法打开该文件。要解决此问题，请确保.xls文件未在任何其他工作簿、应用程序或加载项中打开，然后重试。
修复 8：检查您的权限
MS Excel可能难以打开设置为“只读”的(Read-only)文件。要解决此问题，请确保链接的文件具有正确的写入权限。右键单击该文件并选择属性(Properties)。在“属性”旁边，确保未选中“只读”(Read-only)。
回到数据
MS Office应用程序可能会不稳定，没有什么比Excel错误更糟糕的情况，会拖慢您的工作速度。希望本故障排除指南能够帮助您修复Microsoft Excel工作簿，并且所有外部链接都能正常工作。请记住，如果Excel不再适合您，您可以随时切换到Google Sheets或Smartsheet！
8 Best Ways to Fix “Microsoft Excel Cannot Access the File” Error
If you receive the messagе “Microѕoft Excel cannot access the file”, it means something hаs gone wrong with thе filе pаth. This is a frustrating error, and it can prevent you from oрening important documentѕ.
In this article, we’ll explain how to fix the “Microsoft Excel cannot access the file” error and regain access to your workbooks.
What Causes the Error?
There are three main reasons you could receive this Excel error:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently open workbook.”
Below, we’ll start with the fixes most likely to resolve this error. So, start with Fix 1 and work your way through until the problem goes away.
Fix 1: Ensure External Links are Valid
Since this error often occurs when trying to click links to external workbooks or worksheets, the first step is to ensure that these links are correct. For each link in your Excel spreadsheet:
- Make sure the linked workbooks haven’t been moved or renamed. This will affect the file path and Excel will be unable to find the linked item.
- Delete linked items if you can no longer find them.
To find all external links:
- Open the Excel application.
- Press Ctrl + F to search the workbook.
- Select Options.
- Type “.xlsx” and press Find What.
- Under “Within”, select Workbook and under “Look in”, select Formulas.
- Select Find All.
Fix 2: Update Microsoft Excel
Software updates often fix temporary issues. To make sure this glitch isn’t being caused by an out-of-date Excel program, you should update it to the latest version. To do so:
- Open Excel.
- Select File > Account.
- Select Update Options > Update Now.
Fix 3: Disable Excel Add-ins
Occasionally, add-ins can cause problems with your Excel sheets. To make sure they aren’t causing the “cannot access the file” glitch, disable all add-ins and re-enable them one by one. To do so:
- Open your Excel workbook.
- Select File > Options.
- Select Add-ins.
- Uncheck all boxes and click OK.
- Enable each add-in one by one until the glitch resurfaces.
Fix 4: Shorten the File Path Length
This glitch can be caused by a file path that’s too long. To make sure this isn’t the case, move the Excel files to a parent folder (rather than a chain of sub-folders) and rename it to something short. Once the file path has been shortened, update the link within your Excel workbook and try to open the file.
Fix 5: Move the Excel File to the Desktop
Some users have noted that this error disappears if the Excel file is in the Desktop folder rather than elsewhere in the computer’s file system. While this isn’t a great fix, it can temporarily remove the glitch to return your Excel spreadsheet’s proper functionality.
Note: This error also occurs when the file is stored in a network drive rather than in your local drive. Make sure the file is saved at C:\Users\username\Desktop.
Fix 6: Clear the Office Document Cache
Clearing the Office document cache can resolve this error, too. To do so:
- Open Windows Explorer and head to the Office File Cache. For Office 2016, this is found at “%localappdata%\Microsoft\Office\16.0\OfficeFileCache.” For Office 2013, it can be found at “%localappdata%\Microsoft\Office\15.0\OfficeFileCache.”
- Select all files that start with ‘FS’ and delete them.
- Restart your Excel document and see if the error persists.
Fix 7: Close All Other Programs
One of the causes of this Microsoft Office Excel glitch is that another program is currently using the Excel file, so it cannot be opened. To resolve this, make sure that the .xls file is not open in any other workbooks, apps, or add-ins, and then try again.
Fix 8: Check Your Permissions
MS Excel might struggle to open files that are set to “Read-only”. To resolve this, make sure your linked files have the correct write permissions. Right-click the file and select Properties. Next to “Attributes”, make sure that Read-only is unchecked.
Back to the Data
MS Office apps can be temperamental, and there’s nothing worse than an Excel error to slow down your work. Hopefully, this troubleshooting guide has helped you fix your Microsoft Excel workbook and all external links are working as they should. Keep in mind, if Excel stops working for you, you can always switch to Google Sheets or Smartsheet!
