Office Settings & Configuration

How to Pin Excel Files When PERSONAL.XLSB Blocks the Recent List

Huma Ashraf ChHuma Ashraf Ch Oct 9, 2026 869 views

Question details

The user needs a way to pin specific Excel workbooks for quick access because the hidden PERSONAL.XLSB macro workbook continuously occupies the recent files list.

How to Pin Excel Files When PERSONAL.XLSB Blocks the Recent List
Product
Microsoft Excel
Device & OS
Windows
Scenario
Trying to pin frequently used Excel files for easy access.
Observed behavior
The PERSONAL.XLSB macro workbook repeatedly fills the recent files list in the Excel interface, preventing users from pinning their desired workbooks.
Before you start

Ensure you know the exact file path or folder location of the Excel workbook you want to pin, as you will need to access it outside of Excel's native recent list.

Solution 1Recommended

Create a Shortcut and Pin to the Windows Taskbar

Bypass Excel's recent list by creating a direct desktop shortcut to your workbook and pinning it to the Windows taskbar.

Since Excel does not allow you to exclude the PERSONAL.XLSB file from the recent list, using Windows taskbar shortcuts is the most reliable workaround for quick file access.

1
Create a Desktop Shortcut

Right-click on an empty space on your Windows desktop, select 'New', and then click on 'Shortcut'.

2
Locate Your Excel File

Click the 'Browse' button to navigate to your target Excel workbook, select it, and click 'Next'.

3
Name the Shortcut

Type a recognizable name for your shortcut (e.g., 'Daily Budget Tracker') and click 'Finish'.

4
Pin to Taskbar

Click and drag the newly created shortcut directly onto your Windows taskbar. It will now be pinned for one-click access regardless of Excel's internal list.

Create a Shortcut and Pin to the Windows Taskbar
Custom Icons: You can customize the shortcut icon by right-clicking it, selecting 'Properties', and clicking 'Change Icon' before pinning it to the taskbar.
Free Microsoft Office alternative

Switch to WPS Office for a Cleaner Spreadsheet Experience

Tired of Excel's recent list getting clogged by hidden macro workbooks? WPS Office provides a free, lightweight, and highly compatible alternative. Enjoy an intuitive tabbed interface where managing and pinning your favorite spreadsheets is seamless and bug-free.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installer for Windows.
  2. 2. Install and Set Up: Run the installer and follow the on-screen prompts to complete the lightweight installation.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open or pin your existing Excel files without recent list conflicts.
Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv files.Clean, easy-to-use recent files dashboard without hidden macro clutter.Lightweight software that loads rapidly on all Windows devices.Free to download and use, with a familiar interface that makes migration seamless.
microsoft office alternative - wps office

Frequently Asked Questions

Why does PERSONAL.XLSB keep appearing in my recent files list?

PERSONAL.XLSB is a hidden macro workbook that opens automatically in the background every time you start Excel. Because the application registers it as being opened, it continuously gets pushed to the top of your recent files list.

Can I hide PERSONAL.XLSB from the recent list in Excel?

There is no built-in setting in Microsoft Excel to specifically exclude the PERSONAL.XLSB file from the recent list. The most effective workaround is to pin your important files directly to the Windows taskbar or File Explorer Quick Access.

How do I remove a specific file from Excel's recent list?

Open Excel, click on 'File', and navigate to the 'Recent' tab. Right-click the file you want to remove and select 'Remove from list'. Note that if you run macros, PERSONAL.XLSB will likely reappear upon restarting Excel.