Fix a SharePoint Excel File That Will Not Open After Renaming
Question details
A user needs to open a SharePoint Online Excel file in desktop Excel after renaming it to the name of a deleted file.

- Product
- SharePoint Online and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A SharePoint Online library is mapped as a WebDAV network drive. One Excel file is deleted, and another is renamed to reuse its name.
- Observed behavior
- The renamed file opens in Excel Online but fails to open in desktop Excel from SharePoint or the mapped drive. Renaming it to a different name allows it to open.
Confirm that the renamed file opens in Excel Online and check whether Office has any pending uploads. Finish or resolve pending uploads before clearing cached files, since clearing the cache can remove unsaved local changes.
Clear the Office Document Cache and reopen the file
Use this method when an outdated cache entry may still point to the deleted file.
Office Upload Center is available in some older Office versions; newer versions may not include it. Clearing the cache does not guarantee a fix if the issue has another cause.
Close the affected workbook and exit Excel and other Office apps after resolving any pending uploads.
Search for Office Upload Center in the Start menu, open it, and select Settings.
Under Cache Settings, select the option to delete files from the Office Document Cache when they are closed. Then select Delete cached files or Delete cached information and confirm.
Restart Excel, then open the workbook from the mapped drive or select Open in Excel in the SharePoint library.

Rename the workbook to a different file name
Use a different name as a workaround when the reused name prevents desktop Excel from opening the file.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for an easier migration. Download a workbook from SharePoint to work with it locally; WPS does not repair the Microsoft Office Document Cache.

Frequently Asked Questions
Why does the workbook open online but not in desktop Excel?
An outdated Office Document Cache entry may still reference the deleted file that used the same name. If Office Upload Center is available, clear its cached files and test the workbook again.
Will renaming the workbook fix the problem?
Renaming the workbook to a different name may let desktop Excel open it. Select the file in SharePoint or the mapped drive, choose Rename, and keep the .xlsx extension.
What should I check before clearing the Office cache?
Check Office Upload Center for pending uploads and resolve them first. Clearing cached files can remove local changes that have not been uploaded.
What if I cannot find Office Upload Center?
Office Upload Center is not included in some newer Office versions. Try opening the workbook under a different name and consult Microsoft support guidance for your installed Office version.




