Fix Excel Opening a New Workbook After Closing One
Question details
The user needs to stop Excel from automatically opening a blank workbook whenever an existing workbook is closed.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An existing workbook is closed, but the user wants Excel to remain open without creating another workbook automatically.
- Observed behavior
- Excel opens a new blank workbook after the current workbook is closed.
Close all Excel windows, then reopen Excel in Safe Mode using excel.exe /safe. Note any installed add-ins and check whether startup workbooks or Personal.xlsb are present before changing settings.
Test Excel in Safe Mode and disable the add-in causing new workbooks
Use this solution when an Excel add-in or startup extension may be creating a workbook after the current file closes.
Safe Mode prevents most add-ins and startup customizations from loading. If the issue disappears in Safe Mode, re-enable add-ins one at a time to identify the source.
Press Windows + R, enter excel.exe /safe, and select OK. Close an existing workbook to check whether Excel still opens a blank workbook.
In Excel, select File > Options > Add-ins. At the bottom of the window, choose Excel Add-ins from the Manage list and select Go.
Clear one add-in checkbox at a time, select OK, restart Excel normally, and close a workbook after each test. Remove or update the add-in that causes the behavior.
Check startup workbooks, Personal.xlsb, and VBA code
Use this solution when the problem continues after add-ins are disabled or when Excel opens workbooks through macros and startup folders.
Use WPS Office to Open and Edit Excel Workbooks Without Excel Startup Conflicts
If Excel's add-ins, startup workbooks, or VBA settings continue to interrupt your workflow, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and compatibility for common Excel files. Open your workbook in WPS Spreadsheets and continue editing without relying on Excel-specific startup customizations.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or Applications folder.
- 2. Open the Excel workbook: Select Menu > Open, choose the existing .xlsx or .xls file, and allow WPS Spreadsheets to load it.
- 3. Continue editing without Excel add-ins: Use the WPS Spreadsheets ribbon to edit, save, and export the workbook without loading Microsoft Excel startup workbooks or add-ins.
Frequently Asked Questions
Why does Excel open a blank workbook after I close another workbook?
An Excel add-in, startup workbook, Personal.xlsb macro, or VBA procedure may be calling Workbooks.Add when the active workbook closes. Test Excel with excel.exe /safe to determine whether an add-in is involved.
How can I tell whether an Excel add-in is causing the new workbook to open?
Start Excel with Windows + R, enter excel.exe /safe, and select OK. If the issue stops, go to File > Options > Add-ins, choose Excel Add-ins in the Manage list, select Go, and disable add-ins one at a time.
Where should I look for Excel startup workbooks?
Check the XLSTART folder and the alternate startup file location listed under File > Options > Advanced in the General section. Temporarily move unfamiliar files from those locations and restart Excel.
Can a Personal.xlsb macro create a new workbook automatically?
Yes. Press Alt + F11 and inspect the Personal.xlsb project and relevant workbook event procedures for Workbooks.Add or similar code. Disable or edit the procedure if it runs when a workbook opens or closes.
Will reinstalling Excel remove the automatic new workbook behavior?
Not necessarily. Add-ins, startup files, Personal.xlsb, and user VBA projects can remain after an Office repair or reinstall. Check those items before reinstalling Excel.
