How to Fix Excel in Teams Opening an Outdated Cached File
Question details
Users need to resolve an issue where an Excel file stored in a Teams or SharePoint document library repeatedly opens an older, cached version.
- Product
- Microsoft Excel, Microsoft Teams, SharePoint
- Device & OS
- Windows
- Scenario
- Opening a heavily used shared Excel file from Teams into the Excel desktop application after an application crash.
- Observed behavior
- Excel loads an outdated local cached copy of the file instead of the current server version, preventing successful synchronization and document merges.
Ensure all Microsoft Office applications, including Excel and Microsoft Teams, are completely closed before attempting to clear cached files, as background processes may prevent deletion.
Manually Clear the OfficeFileCache Folder
Deleting the corrupted local cache folder forces Excel to ignore the local error state and download a fresh copy from SharePoint.
When Excel crashes, the local synchronization state can become corrupted. Manually deleting the Office cache folder is often the most effective way to force a completely fresh synchronization from the server.
Completely exit Microsoft Excel, Microsoft Word, and Microsoft Teams. Check your system tray to ensure Teams is not running in the background.
Press Windows Key + R to open the Run dialog. Type %localappdata%\Microsoft\Office and press Enter. Open the folder named '15.0' or '16.0' (depending on your Office version).
Locate the folder named 'OfficeFileCache'. Right-click the folder and select 'Delete'. If prompted that files are in use, double-check that all Office processes are closed in Task Manager.
Reopen Microsoft Teams, navigate to the SharePoint document library, and open the Excel file again. Excel will now download the latest live version from the server.
Clear Document Cache via Excel Options
Use the built-in Excel feature to delete cached files without navigating Windows directories.
Try WPS Office for Seamless and Lightweight Spreadsheet Management
If you frequently encounter caching and synchronization errors with Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free alternative for your spreadsheet needs.
- 1. Download the Installer: Visit the official WPS website and click the free download button to get the latest version.
- 2. Install WPS Office: Run the downloaded executable file and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without formatting loss.
Frequently Asked Questions
Why does Excel keep opening an older version of my shared file?
This happens when the local Office Document Cache becomes corrupted, typically after an application crash or network interruption. Excel attempts to read from the faulty local copy instead of fetching the live server version from SharePoint.
Does clicking 'Delete cached files' in Excel Options clear everything?
The built-in button clears standard cached files, but in cases of severe corruption or sync-blocking errors, it may leave behind problematic metadata. Manually deleting the entire OfficeFileCache folder in the Windows AppData directory is a more thorough solution.
Where is the Office cache folder located on Windows?
It is typically located at C:\Users\[Username]\AppData\Local\Microsoft\Office\[Version]\OfficeFileCache. The version folder is usually '15.0' for Office 2013 or '16.0' for Office 2016, 2019, and Microsoft 365.
How can I safely recover my data if the cached version won't merge?
If the local cached version has errors preventing a merge, use 'Save As' to save a local copy of your un-synced work under a different name. Then, clear your cache, open the fresh server version from Teams, and manually copy your recent changes into the correct file.
