How to Clear or Reduce Recent Items When Inserting Excel Links
Question details
The user needs to reduce or clear the long list of recent Office files shown when inserting a link in Excel.
- Product
- Microsoft Excel in Microsoft Office 2016 or later
- Device & OS
- Windows
- Scenario
- The user opens Excel's Link dialog and wants to manage the recent files and items displayed there.
- Observed behavior
- The Link dialog displays a long list of recent Office files and other items.
Close all Excel windows before changing the recent-item setting or editing the Excel registry key. If you plan to use the registry command, confirm that you are working with the correct Office version, such as 16.0 for Office 2016 or later.
Reduce the number of recent items in Excel Options
Use this method when you want to keep recent-item access but display a shorter list in Excel.
This changes how many recent workbooks Excel displays without deleting the underlying recent-file records from Windows or Office.
Open Excel, select File, and choose Options from the lower-left corner.
In Excel Options, select Advanced and scroll to the Display section.
Set Show this number of Recent Workbooks to a smaller number, then select OK to save the change.
Open the Insert Hyperlink or Link dialog again and review the reduced recent-items list.
Clear Excel recent-file records with Command Prompt
Use this method when you want to remove the Excel File MRU records completely rather than only reduce the displayed count.
Manage Excel-compatible workbooks with a cleaner WPS Office workflow
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and strong compatibility with Excel files. It supports seamless migration for users who want to create and edit spreadsheets without relying on the Microsoft Office recent-items configuration.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or applications list.
- 2. Open an Excel workbook: Select Open from the home screen and choose an XLSX or XLS file from your device.
- 3. Edit and manage the spreadsheet: Use the familiar spreadsheet interface to update formulas, links, and workbook content.
- 4. Save in an Excel-compatible format: Select Menu or File, choose Save As, and select XLSX or XLS when you need Microsoft Excel compatibility.

Frequently Asked Questions
Where can I limit the number of recent workbooks shown in Excel?
Open Excel and go to File > Options > Advanced. In the Display section, change Show this number of Recent Workbooks to the number you prefer, then select OK.
How do I clear Excel's recent-file list completely?
Close Excel, open Windows Command Prompt, and run reg delete "HKCU\Software\Microsoft\Office\16.0\Excel\File MRU" /f. Reopen Excel after the command finishes.
Does the registry command work with every Excel version?
The 16.0 registry path is used by Office 2016 and later. Earlier Office versions may use a different version number, so verify the installed Office version before running a registry command.
Will reducing the recent-workbook count delete my files?
No. Changing the count in File > Options > Advanced only limits the number of recent workbooks Excel displays; it does not delete the original files.




