File Cannot Open

How to Fix Excel Cannot Open Book File Error at Startup

Steve KSteve K Nov 10, 2026 870 views

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.

How to Fix Excel Cannot Open Book File Error at Startup
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.
Before you start

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.

Solution 1Recommended

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.

1
Close the application

Make sure Microsoft Excel is fully closed. Check your taskbar to ensure no Excel windows are currently active.

2
Open File Explorer

Press the Windows Key + E on your keyboard to open File Explorer.

3
Navigate to the XLSTART directory

Click on the address bar at the top of the window, type or paste %appdata%\Microsoft\Excel\XLSTART, and press Enter.

4
Remove problematic files

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.

5
Restart Excel

Launch Microsoft Excel again to verify if the startup error has been successfully resolved.

Clear the XLSTART Folder
Keep Personal Macros Intact: The PERSONAL.XLSB file contains your saved personal macros. Deleting it will remove your customized macros, so always leave it in the XLSTART folder.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and download the free installer for Windows.
  2. 2. Install the Software: Run the downloaded executable file and follow the simple on-screen instructions to complete the setup.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and directly open your existing .xlsx files safely and quickly.
Free and lightweight alternative to Microsoft Excel.Fully compatible with all major Microsoft Office formats, including .xlsx, .xls, and .csv.No complicated XLSTART folder bugs or recurring startup crashes.Familiar user interface ensuring seamless migration with zero learning curve.
microsoft office alternative - wps office

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.