How to Fix Excel "File Could Not Be Found" Error When Opening a Workbook
Question details
The user is experiencing a recurring error stating that a specific file cannot be found when opening an Excel workbook, even though the missing file was moved and supposedly has no relation or link to the current workbook.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening a specific Excel workbook after another seemingly unrelated file has been moved or deleted.
- Observed behavior
- Excel displays a "File Could Not Be Found" error message referencing the moved file every time the workbook is opened, likely due to hidden external links or cached references.
Ensure that you have saved any open workbooks and completely closed all Microsoft Office applications before attempting to clear the system cache.
Clear the Office File Cache
Resolves persistent errors caused by outdated or corrupt cached references to moved files.
Microsoft Office maintains a background cache of files to improve performance. When a file is moved or deleted, the cache may still hold onto the old reference, triggering a "File Could Not Be Found" error even if the workbooks are not directly linked.
Sign out of your Microsoft Office account and completely close all Office applications, including Excel and Word.
Open Windows File Explorer and navigate to C:\Users\username\AppData\Local\Microsoft\Office\16.0\OfficeFileCache. Be sure to replace 'username' with your actual Windows username.
Select all files and folders within the OfficeFileCache directory and delete them to clear the outdated references.
Open Excel, sign back into your Microsoft account, and open the problematic workbook to verify the error is resolved.
Find and Remove Hidden External Links
Identifies and removes hidden references to the missing file that are embedded within the workbook's formulas or settings.
Try WPS Office to Avoid Excel Cache and Link Errors
Frustrated by persistent "File Could Not Be Found" errors and complex cache issues in Microsoft Excel? WPS Office offers a lightweight, highly compatible alternative that processes spreadsheets efficiently without bloated background caches. It seamlessly opens your existing Excel files and provides a familiar interface so you can get right back to work.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
- 2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file directly without worrying about legacy Office cache errors.
- 3. Manage links easily: Navigate to the Data tab in WPS Spreadsheet to view and manage any external links cleanly and efficiently.
Frequently Asked Questions
Why does Excel say a file cannot be found when I haven't linked it?
Excel may have created a hidden reference automatically, such as in a copied named range, a data validation drop-down, or a conditional formatting rule. Alternatively, the Office File Cache might be holding onto an outdated background reference to a file you recently moved or deleted.
Where is the Office File Cache located on my computer?
For recent versions of Microsoft Office, the cache is typically located at C:\Users\username\AppData\Local\Microsoft\Office\16.0\OfficeFileCache. You will need to replace 'username' with your actual Windows username, and '16.0' might vary slightly depending on your specific Office version.
Will breaking an external link delete my spreadsheet data?
No, breaking an external link will not delete your data. It will simply convert any formulas that relied on the external file into their current static values, preventing Excel from trying to fetch new data from the missing file.
