SharePoint Document Issues

Fix a SharePoint Excel File That Will Not Open After Renaming

Jason MillerJason Miller Nov 20, 2026 870 views

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.

Fix a SharePoint Excel File That Will Not Open After Renaming
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.
Before you start

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.

Solution 1Recommended

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.

1
Close Office files

Close the affected workbook and exit Excel and other Office apps after resolving any pending uploads.

2
Open Upload Center settings

Search for Office Upload Center in the Start menu, open it, and select Settings.

3
Clear cached files

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.

4
Test the renamed workbook

Restart Excel, then open the workbook from the mapped drive or select Open in Excel in the SharePoint library.

Clear the Office Document Cache and reopen the file
Upload Center unavailable?: If Office Upload Center is not installed, use the different-name workaround below and check the Microsoft support guidance for your Office version.
Free Microsoft Office alternative

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.

Open and edit downloaded Excel workbooks in WPS SpreadsheetCompatible with Microsoft Excel .xlsx filesFamiliar spreadsheet interface for a smoother transitionFree and lightweight Office alternative
microsoft office alternative - wps office

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.