Your Personal Macro Workbook, PERSONAL.XLSB, is not loading when you start Excel. This file stores your global macros and is meant to open automatically in the background. The problem is often caused by a corrupted file, a blocked location, or a disabled add-in. This article explains how to find, repair, and restore your personal macros.
Key Takeaways: Recovering Your Personal Macro Workbook
- Developer > Macros > Edit: Opens the Visual Basic Editor to check if PERSONAL.XLSB is listed in the Project Explorer.
- File > Options > Trust Center > Trust Center Settings > Trusted Locations: Verifies the correct folder path where PERSONAL.XLSB should be stored.
- Open and Repair command: Attempts to recover data from a corrupted PERSONAL.XLSB file when opening it from the File menu.
Why PERSONAL.XLSB Fails to Load in Excel
The Personal Macro Workbook is a hidden file that Excel tries to load from a specific trusted location. If it does not load, Excel may show an error message or simply start without your macros available. The most common cause is file corruption, which can happen if Excel or your computer shuts down unexpectedly while the file is open. Another reason is the file being moved, renamed, or deleted from its default folder. Security settings or add-in conflicts can also prevent Excel from loading the file automatically on startup.
Steps to Recover and Restore PERSONAL.XLSB
Follow these methods in order to diagnose and fix the loading issue.
Method 1: Check and Enable the PERSONAL.XLSB Add-in
- Open Excel and go to the Developer tab
If the Developer tab is not visible, right-click the ribbon and select Customize the Ribbon. Check the box for Developer in the right-hand list. - Click Macros in the Code group
This opens the Macro dialog box. Look in the “Macros in” dropdown. If PERSONAL.XLSB is loaded, you will see its macros listed here. - Open the Visual Basic Editor with Alt + F11
In the Project Explorer pane on the left, look for a project named “PERSONAL.XLSB”. If it is missing, the file is not loaded. Close the editor. - Go to File > Options > Add-ins
At the bottom of the window, ensure “Excel Add-ins” is selected in the Manage dropdown, then click Go. - Check the box for “PERSONAL.XLSB” in the Add-ins available list
If it is listed, check its box and click OK. Restart Excel to see if it loads.
Method 2: Locate and Repair the Corrupted File
- Find the default PERSONAL.XLSB location
Open File Explorer and paste this path into the address bar:%appdata%\Microsoft\Excel\XLSTART. This is the trusted startup folder. - Look for the PERSONAL.XLSB file
If the file is present, note its size and modified date. A file size of 0 KB indicates corruption. - Attempt to open and repair the file
Start Excel. Go to File > Open > Browse. Navigate to the XLSTART folder. Select PERSONAL.XLSB, click the dropdown arrow on the Open button, and choose Open and Repair. - Choose “Repair” when prompted
Excel will try to recover as much data as possible. If this fails, try the “Extract Data” option to salvage the VBA code modules. - Create a new Personal Macro Workbook if needed
If the file is missing or unrecoverable, record a simple macro in Excel. In the Record Macro dialog, choose “Personal Macro Workbook” as the store location. This creates a new, clean PERSONAL.XLSB file.
If PERSONAL.XLSB Still Does Not Load
After trying the core fixes, these specific scenarios may require additional steps.
Excel Shows “File Format Not Valid” Error
This error means the file is severely corrupted. Rename the old file in the XLSTART folder to PERSONAL_OLD.XLSB. Then, use Method 2, Step 5 to create a new one. You can manually copy your macro code from the old file by opening it in a text editor or trying to import modules into the new workbook via the Visual Basic Editor.
Macros Are Disabled by Trust Center Settings
If all macros are disabled, PERSONAL.XLSB will not run. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Select “Disable all macros with notification” or “Enable all macros”. Click OK twice and restart Excel. Ensure the XLSTART folder is also listed as a Trusted Location in the Trust Center.
Another Add-in Is Causing a Conflict
Start Excel in Safe Mode by holding Ctrl while clicking the Excel icon. If PERSONAL.XLSB loads in Safe Mode, a conflicting add-in is the cause. In normal mode, go to File > Options > Add-ins. Disable other add-ins one by one, restarting Excel each time, to find the conflict.
Manual Recovery vs. Automatic Repair: Key Differences
| Item | Manual Recovery (Open and Repair) | Automatic Recreation (Record New Macro) |
|---|---|---|
| Best for | Partially corrupted files with salvageable code | Missing or completely corrupted files |
| Effort required | Medium – requires navigation and decision prompts | Low – a single macro recording triggers creation |
| Data recovery | Attempts to restore original VBA modules and sheet data | Starts fresh; old macros must be copied manually |
| Success rate | Variable, depends on corruption level | Guaranteed to create a working file |
| Next step if fails | Use “Extract Data” or manual code copy | Import modules from a backup into the new file |
You can now restore your Personal Macro Workbook when it fails to load. Check the XLSTART folder first and use the Open and Repair feature. For persistent issues, create a new file and import your saved macros. To prevent future loss, regularly export your VBA modules from the Visual Basic Editor via File > Export File. Use Alt + F11 to quickly access the editor and manage your projects.