“Personal.xlsb” Errors: Troubleshooting the Hidden Startup Workbook

The Personal Macro Workbook (PERSONAL.XLSB) is a hidden workbook that opens in the background whenever you launch Excel. It serves as a global repository for your personal macros and custom automation tools.

When this file becomes corrupt, gets placed into Excel’s quarantine, or suffers a permission lock, Excel may freeze at startup, throw error messages, open duplicate “Read-Only” instances, or lose access to your saved macros entirely.

Quick Answer

Most PERSONAL.XLSB issues stem from the file becoming corrupted or flagged as a “Disabled Item” after an Excel crash.

To unhide and repair it: In Excel, go to the View tab and click Unhide. Select PERSONAL.XLSB and click OK.

If Excel refuses to open it or marks it disabled: Go to File > Options > Add-ins, change the bottom drop-down to Disabled Items, click Go, select PERSONAL.XLSB, and click Enable.

---

Common Personal.xlsb Symptoms and Causes

The file resides in your local roaming user profile:
C:\Users\<Username>\AppData\Roaming\Microsoft\Excel\XLSTART\

Because it opens silently on every application startup, any structural defect in PERSONAL.XLSB interrupts Excel’s boot sequence.

Symptom	Underlying Cause	First Action
“PERSONAL.XLSB is locked for editing”	A hidden ghost process (EXCEL.EXE) is running in the background, or an owner file (~$PERSONAL.XLSB) was left behind.	Terminate Excel processes via Task Manager; delete temporary lock files.
Macros do not run / “Record Macro” fails	Excel placed PERSONAL.XLSB into the Disabled Items list following a previous crash.	Re-enable the file via File > Options > Add-ins > Disabled Items.
PERSONAL.XLSB opens as a visible window	The file’s hidden window state was saved while visible.	Click View > Hide Window, then close and save Excel.
Excel crashes immediately on startup	Corrupted compiled VBA binary code inside the .xlsb structure.	Move the file out of XLSTART to a backup directory and rebuild.

---

Step-by-Step Troubleshooting Guide

Work through these solutions based on the symptom you are encountering.

Issue 1: Fixing the “File In Use” or “Locked for Editing” Prompt

If Excel states that PERSONAL.XLSB is locked for editing by “another user” (often your own username) and gives you only “Read-Only” or “Notify” options:

1. Close all visible Excel windows.
2. Press Ctrl + Shift + Esc to launch the Windows Task Manager.
3. Select the Details tab.
4. Look for any instances of EXCEL.EXE. If found, click End Task on each one. (Background processes left open by automated scripts or crashed sessions keep a lock on the startup file).
5. Open Windows File Explorer and navigate to:
   %APPDATA%\Microsoft\Excel\XLSTART
6. Look for hidden files starting with a tilde and dollar sign (e.g., ~$PERSONAL.XLSB).
   • Note: If hidden files are not visible, click View > Show > Hidden items in File Explorer.
7. If an owner file (~$PERSONAL.XLSB) exists while Excel is closed, delete it. It is an abandoned lock file.
8. Relaunch Excel normally.

If file locks continue to occur across reboots, see “The file is locked for editing”: How to kill “Ghost” owner files (~$filename) for guidance on stopping orphaned file handles.

Issue 2: Re-enabling a Quarantined PERSONAL.XLSB

If your macros are missing and recording a new macro to the Personal Macro Workbook returns an error:

1. Open Excel and navigate to File > Options.
2. Click Add-ins in the left menu.
3. At the bottom of the window, click the Manage drop-down menu, select Disabled Items, and click Go…
4. If PERSONAL.XLSB is listed in the box, select it and click Enable.
5. Close the dialog, click OK, and restart Excel.

File > Options > Add-ins
  └── Manage: Disabled Items [Go...]
        └── Select: PERSONAL.XLSB
              └── Click [Enable] -> Restart Excel

Issue 3: Re-hiding a Visible PERSONAL.XLSB Window

If PERSONAL.XLSB appears as an empty grid every time you launch Excel:

1. Click on the visible PERSONAL.XLSB window.
2. Go to the View tab on the ribbon.
3. In the Window group, click the Hide button.
4. Close Excel completely.
5. When prompted: “Do you want to save the changes you made to the Personal Macro Workbook?”, click Save.

The workbook is now configured to open silently in the background on subsequent boots.

Issue 4: Recovering Code from a Corrupted PERSONAL.XLSB

If Excel crashes instantly whenever PERSONAL.XLSB loads, the workbook’s compiled VBA code is corrupted. You must clear the file out of the startup path to stabilize Excel, then extract your macro code.

1. Close Excel.
2. Press Win + R, paste the following string, and press Enter:
   %APPDATA%\Microsoft\Excel\XLSTART
3. Cut PERSONAL.XLSB from this folder and paste it onto your Desktop.
4. Launch Excel. It should now open instantly without crashing.
5. In Excel, click File > Open > Browse, navigate to your Desktop, select PERSONAL.XLSB, and open it.
6. Press Alt + F11 to enter the Visual Basic Editor.
7. In the Project Explorer pane on the left, expand VBAProject (PERSONAL.XLSB).
8. Right-click each module under the Modules folder and select Export File… to save your code as .bas text files.
9. Close Excel, delete the corrupted PERSONAL.XLSB from your Desktop, open a blank Excel session, record a temporary dummy macro to create a brand-new PERSONAL.XLSB, open the VBE, and import your clean .bas files via File > Import File…