Office Settings & Configuration

How to Clear or Reduce Recent Items When Inserting Excel Links

Khadija KhanKhadija Khan Nov 12, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Open Excel, select File, and choose Options from the lower-left corner.

2
Open Advanced display settings

In Excel Options, select Advanced and scroll to the Display section.

3
Change the recent workbook count

Set Show this number of Recent Workbooks to a smaller number, then select OK to save the change.

4
Check the Link dialog

Open the Insert Hyperlink or Link dialog again and review the reduced recent-items list.

Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or applications list.
  2. 2. Open an Excel workbook: Select Open from the home screen and choose an XLSX or XLS file from your device.
  3. 3. Edit and manage the spreadsheet: Use the familiar spreadsheet interface to update formulas, links, and workbook content.
  4. 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.
Free, lightweight spreadsheet software for everyday workbook editingFamiliar menus and tools make it easy to migrate from ExcelCompatible with Microsoft Excel XLSX and XLS formatsCreate, edit, and share spreadsheets across supported devices
microsoft office alternative - wps office

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.