VBA & Macro Problems

Fix PERSONAL.xlsb Opening as a Blank Workbook in Excel

Elise WilliamsElise Williams Oct 16, 2026 872 views

Question details

The user wants to resolve an issue where an extra blank workbook unexpectedly opens upon launching the application due to the PERSONAL.xlsb file.

How to Fix PERSONAL.xlsb Opening as a Blank Workbook in Excel
Product
Microsoft Excel
Device & OS
Windows
Scenario
After reinstalling Windows or updating Microsoft 365, the user placed the PERSONAL.xlsb file into the XLStart folder to enable global macros.
Observed behavior
Instead of staying hidden in the background, PERSONAL.xlsb causes the software to launch an additional, visible blank workbook on startup.
Before you start

Before modifying any system folders or macro files, completely close all instances of Microsoft Excel and create a backup copy of your PERSONAL.xlsb file to a safe location on your desktop.

Solution 1Recommended

Hide the Personal Macro Workbook Window

The most common reason PERSONAL.xlsb opens as a visible blank workbook is that its window state was previously saved as visible. Hiding the window directly in the application usually resolves this.

By default, the Personal Macro Workbook is designed to run in the background. If it becomes unhidden, Excel will display it as a blank workbook every time the application starts.

1
Open Excel

Launch Microsoft Excel. If the blank PERSONAL.xlsb workbook appears, click on it to ensure its window is active.

2
Navigate to the View Tab

On the top ribbon interface, click on the 'View' tab to access window visibility settings.

3
Hide the Workbook

Locate the 'Window' group on the ribbon and click the 'Hide' button. The blank workbook will disappear from your screen.

4
Save Changes on Exit

Close Excel completely. A prompt will appear asking if you want to save the changes you made to the Personal Macro Workbook. Click 'Save' to ensure it remains hidden on future startups.

Hide the Personal Macro Workbook Window
Window State Saved: Once saved, PERSONAL.xlsb will continue to load your macros silently in the background without cluttering your workspace.
Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

If you are tired of troubleshooting complex Excel macro issues or dealing with unexpected startup behaviors after Microsoft 365 updates, WPS Office offers a highly compatible alternative. Enjoy a familiar interface and reliable spreadsheet functionalities without the hassle.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv files.Lightweight installation that uses fewer system resources and loads instantly without startup errors.Familiar user interface with an intuitive tabbed workspace for easier multitasking.Free to use with comprehensive spreadsheet functionalities suitable for daily tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Where is the XLStart folder located on a Windows PC?

By default, the XLStart folder is located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. Any compatible file placed in this folder will automatically open when the spreadsheet application launches.

How do I safely delete or disable PERSONAL.xlsb?

To remove the Personal Macro Workbook, close the application completely, navigate to the XLSTART folder in your Windows File Explorer, and either delete the PERSONAL.xlsb file or move it to a different backup directory.

Why do macros in PERSONAL.xlsb suddenly stop working?

This often occurs if the application disables the workbook following a crash, or if macro security settings are too restrictive. You can re-enable disabled items by going to File > Options > Add-Ins, selecting 'Disabled Items' from the Manage dropdown, and clicking 'Go'.