Fix PERSONAL.xlsb Opening as a Blank Workbook in Excel
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.

- 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 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.
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.
Launch Microsoft Excel. If the blank PERSONAL.xlsb workbook appears, click on it to ensure its window is active.
On the top ribbon interface, click on the 'View' tab to access window visibility settings.
Locate the 'Window' group on the ribbon and click the 'Hide' button. The blank workbook will disappear from your screen.
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.

Inspect VBA Code for Startup Events
If hiding the workbook does not work, the issue may stem from VBA code inside PERSONAL.xlsb that explicitly forces a new workbook to open upon startup.
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.

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'.




