File Cannot Open

How to Fix Cannot Delete a Missing File from Excel Recent Documents

Phi Hung Vo Sep 27, 2026 869 views

Question details

The user is unable to delete a stale file entry from the Excel Recently Opened list, resulting in an item-not-found error.

How to Fix Cannot Delete a Missing File from Excel Recent Documents

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to clean up the Recent Documents list by removing an old spreadsheet that has already been deleted or moved from OneDrive.
Observed behavior: Excel displays an item-not-found error and fails to remove the shortcut from the Recent list because the file no longer exists in its original OneDrive location.

Before you start

Verify that the file has actually been deleted or moved from its original local or OneDrive folder, and ensure you have an active internet connection if syncing with OneDrive.

Solution 1Recommended

Clear Unpinned Items from the Recent List

Clearing all unpinned items forces Excel to refresh its cache, removing stale shortcuts to deleted or missing files.

The Recent list in Excel stores a history of file shortcuts, not the files themselves. When a file is removed from OneDrive directly, Excel's cache may become stale. Clearing unpinned items is the fastest way to resolve this discrepancy.

Open Excel Recent Documents

Launch Microsoft Excel and navigate to the 'Home' or 'Open' tab to view your Recent list.

Right-click a Recent File

Right-click on any file currently visible in the Recent Documents list.

Select Clear Unpinned Items

Click on 'Clear unpinned Items' from the context menu.

Confirm the Action

Click 'Yes' on the prompt to confirm. This will clear the stale cache and remove the missing file entry.

Clear Unpinned Items from the Recent List

Important: This action will remove all unpinned files from your recent history. If you have files you want to keep in the list, ensure you click the pin icon next to them before clearing.

Solution 2

Remove the Specific File from the List

Attempting to use the native 'Remove from list' function to delete the specific stale entry without clearing your entire history.

Solution 3

Sign Out and Sign Back Into Office

Refreshing your account connection can force OneDrive and Excel to synchronize their file states.

Free Microsoft Office alternative

Try WPS Office for a Smoother Spreadsheet Experience

If you frequently encounter syncing glitches or cached file errors with Microsoft Excel and OneDrive, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool with straightforward file management.

1. Download WPS Office: Visit the official WPS website and download the free installation package.
2. Install the Application: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly, with full format compatibility.

Seamless compatibility with Microsoft Excel (.xlsx, .xls) and CSV formatsIntuitive and easy-to-manage recent file history without forced cloud syncing issuesLightweight application that runs smoothly on older and modern devicesCompletely free core spreadsheet features

microsoft office alternative - wps office

Frequently Asked Questions

Why does a deleted file still appear in my Excel Recent list?

The Recent list in Excel stores shortcuts (file history), not the actual files. When you delete a file from OneDrive or your local drive, the shortcut may remain in Excel's cache until the application fully syncs or the cache is cleared.

Can I remove a single missing file from the Recent list instead of all of them?

Yes, you can right-click the specific file and select 'Remove from list'. However, if this triggers an item-not-found error, the cache is stuck, and you may need to use the 'Clear unpinned Items' option instead.

Will clearing unpinned items delete my actual Excel files?

No. Clearing unpinned items only removes the history shortcuts from the Recent list. It does not delete, move, or modify any actual spreadsheets stored on your hard drive or in OneDrive.

How do I prevent important files from disappearing when I clear the list?

Before clearing your recent history, hover over any important file in the list and click the pin icon on the right side. Pinned items are excluded when you select 'Clear unpinned Items'.

Document & File Issues