How to Fix Excel Cannot Open Book File Error at Startup
Question details
The user encounters an invalid file format or extension error for a 'Book' file (e.g., Book 9.xlsx) every time Microsoft Excel is launched.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Starting the Microsoft Excel application.
- Observed behavior
- An error message appears at startup stating that the file format or extension is invalid, preventing the application from opening smoothly.
Ensure that Microsoft Excel is completely closed before attempting to modify any system or startup folders. You should also verify you have administrative access to open the File Explorer paths required.
Clear the XLSTART Folder
Remove unintended or corrupted files from Excel's primary startup directory to resolve the invalid format error upon launch.
Excel automatically tries to open any files located in the XLSTART folder when it boots. If a corrupted or incorrectly formatted file accidentally ends up in this folder, it triggers a startup error.
Make sure Microsoft Excel is fully closed. Check your taskbar to ensure no Excel windows are currently active.
Press the Windows Key + E on your keyboard to open File Explorer.
Click on the address bar at the top of the window, type or paste %appdata%\Microsoft\Excel\XLSTART, and press Enter.
Select any files in this folder (such as Book 9.xlsx) and delete or move them to your Desktop. Do not delete the PERSONAL.XLSB or PERSONAL files if they are present.
Launch Microsoft Excel again to verify if the startup error has been successfully resolved.

Check Alternate Startup Folders and Add-ins
Inspect Excel's advanced options for alternate startup locations and disable suspicious COM Add-ins that might be forcing a corrupted file to open.
Try WPS Office for a Bug-Free Spreadsheet Experience
If you are tired of persistent startup errors and corrupted configuration files in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free spreadsheet application that opens your .xlsx workbooks instantly without startup folder crashes.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installer for Windows.
- 2. Install the Software: Run the downloaded executable file and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and directly open your existing .xlsx files safely and quickly.

Frequently Asked Questions
What is the XLSTART folder in Excel?
The XLSTART folder is a dedicated system directory where Excel automatically looks for workbooks, templates, or macros to open every time the program launches. If a corrupted file is accidentally saved here, it causes format errors upon startup.
Why does the error specifically mention 'Book 9.xlsx' or similar names?
Excel automatically assigns sequential default names like Book 1, Book 2, etc., to new unsaved workbooks. If one of these unsaved temporary files gets improperly lodged in the startup folder and becomes corrupted, the application will display an error naming that specific file when opening.
Will I lose my macros if I delete files in the XLSTART folder?
You will not lose your personal macros as long as you do not delete the PERSONAL.XLSB or PERSONAL files. Make sure you only remove the specific unintended workbook files (like Book 9.xlsx) that are causing the startup error.




