When Microsoft Excel crashes on launch, freezes on the “Starting…” splash screen, opens unwanted blank files automatically, or fails to load personal macros, the XLSTART startup folder is usually corrupted. Excel automatically opens every workbook, template, and shortcut placed inside its startup directories whenever the application launches. If a file inside this directory becomes damaged, is saved in an unreadable format, or contains a broken macro, Excel’s startup sequence stalls or terminates.
Fast Fix
Close Excel. Press Windows Key + R, paste
%appdata%\Microsoft\Excel\XLSTART, and press Enter. Move all files in this folder (includingPERSONAL.XLSB) to a temporary folder on your desktop. Launch Excel; if it opens cleanly without errors, move the files back one at a time to identify the damaged file.
Diagnostic Snapshot
| Symptom | Probable Cause | Action |
|---|---|---|
| Excel crashes at the splash screen on launch | Damaged binary stream in PERSONAL.XLSB or corrupted startup template | Clear the user and system XLSTART directories. |
| Two workbooks open every time Excel launches | A standard workbook was accidentally saved directly into XLSTART | Remove non-template workbooks from the startup path. |
| Calculation mode resets unexpectedly on launch | Book.xltx or Sheet.xltx in XLSTART was saved with incorrect calculation settings | Delete or resave templates with intended calculation modes. |
| Excel opens in Safe Mode, but fails normal launch | Startup file or add-in in XLSTART is conflicting with the main thread | Isolate files using Safe Mode diagnostic steps. |
Understanding Excel’s Startup Directories
Excel monitors multiple locations on your computer to load startup workbooks and templates:
Excel Launch Triggered
│
├── 1. User XLSTART Folder
│ %appdata%\Microsoft\Excel\XLSTART
│ (Houses PERSONAL.XLSB and custom Book.xltx / Sheet.xltx)
│
├── 2. System-Wide XLSTART Folder
│ C:\Program Files\Microsoft Office\root\Office16\XLSTART
│ (Applies to all Windows user profiles on the machine)
│
└── 3. Alternate Startup Path (Configured in Options)
File > Options > Advanced > General > "At startup, open all files in"
If an invalid shortcut, an incomplete download, an untrusted script, or a non-Excel file is placed into any of these three locations, Excel tries to parse it as a valid workbook during initialization. When the parser fails, the entire application locks up.
Step-by-Step Resolution
Step 1: Clear the User-Specific XLSTART Directory
The primary user startup folder is where personal macro workbooks (PERSONAL.XLSB) and custom default templates live.
- Ensure Excel is closed. Open Task Manager (Ctrl + Shift + Esc) and end any hanging
EXCEL.EXEtasks under Background Processes. - Press Windows Key + R to open the Run prompt.
- Paste the following path and press Enter:
%appdata%\Microsoft\Excel\XLSTART - Create a new folder on your desktop named
XLSTART_Backup. - Select all items in the
XLSTARTfolder, cut them (Ctrl + X), and paste them (Ctrl + V) into the desktop backup folder. - Launch Excel normally.
- If Excel opens quickly and without errors, the corruption was located inside this folder. Proceed to Step 4 to salvage your macros.
- If Excel still crashes, leave the folder empty and proceed to Step 2.
Step 2: Clear the System-Wide Program Files XLSTART Directory
If your computer was configured by an enterprise IT team, add-ins or templates may have been placed in the global installation directory, which affects all users.
- Press Windows Key + R.
- For 64-bit Office on 64-bit Windows, paste:
C:\Program Files\Microsoft Office\root\Office16\XLSTART(If you are running 32-bit Office, paste:C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART). - Press Enter. (You may need local administrator approval to access this folder).
- If you see files, templates, or add-in shortcuts here, move them to your desktop backup folder.
- Launch Excel to test whether the startup issue is resolved.
Step 3: Clear the Alternate Startup Path in Excel Options
Excel includes a setting that allows users to designate an external network drive or local folder as a supplementary startup directory. If that folder points to an unreachable network location or contains invalid files, startup will hang.
- Launch Excel in Safe Mode by pressing Windows Key + R, typing
excel /safe, and clicking OK. (If Safe Mode fails to launch, see How to Fix “Excel could not open in Safe Mode” Diagnostic). - Click File > Options.
- Select Advanced from the left-hand menu.
- Scroll down to the General section near the bottom.
- Look at the box labeled At startup, open all files in:.
- If there is a file path written in this box, clear the field completely so it is blank.
- Click OK, close Excel, and restart the application normally.
Step 4: Repair or Salvage a Corrupted PERSONAL.XLSB File
If clearing the user XLSTART folder resolved your launch crash, the corrupted file is almost certainly your PERSONAL.XLSB macro workbook. To recover your macros without reintroducing the crash:
- Open Excel to an empty workbook.
- In File Explorer, rename the backed-up file from
PERSONAL.XLSBtoPERSONAL_OLD.XLSB. - Open
PERSONAL_OLD.XLSBvia File > Open > Browse. - If it opens, press Alt + F11 to launch the Visual Basic Editor.
- Right-click each code module under the
VBAProject (PERSONAL_OLD.XLSB)tree, select Export File…, and save each module as a.basfile on your desktop. - Close Excel.
- In Excel, record a temporary new macro (View > Macros > Record Macro), select Personal Macro Workbook in the “Store macro in” dropdown, and click OK. Stop the recording immediately. This creates a clean, uncorrupted
PERSONAL.XLSBfile in yourXLSTARTfolder. - Press Alt + F11, right-click inside the new project, select Import File…, and import the
.basfiles you exported in step 5.
For additional issues where corrupted templates force Excel to launch in manual calculation mode, see How to Resolve “Automatic Calculation” Turning Off Spontaneously and “Calculation is set to Manual” but keeps switching back.
Hard Stops and Diagnostic Checks
- Crash Continues with All XLSTART Folders Empty: If Excel continues crashing on startup even when all
XLSTARTfolders are empty and the alternate startup path is blank, the issue is not startup folder corruption. It is an unhandled application exception caused by COM add-ins, registry corruption, or a damaged installation. Follow the diagnostic steps in “Excel has stopped working” (Kernelbase.dll Errors). - Read-Only or Network Disconnect Errors on Startup: If your
XLSTARTpath is redirected to a network share or OneDrive via folder redirection policies, loss of internet connectivity will freeze Excel on launch. Startup directories should always be mapped to a local, non-synced drive path.