The Unwanted Autoload
When you launch Microsoft Excel from your Start menu or taskbar, you generally expect it to open a fresh, blank workbook or display the Start Screen so you can choose what to work on. However, depending on how you closed the application previously, or if Excel recovered from a crash, it might aggressively bypass the Start Screen and automatically open the exact spreadsheet you were working on yesterday. This can be problematic if that file contains sensitive data you don’t want flashing on your screen, or if it is a massive, complex file that takes several minutes to load.
How to Disable the Recovery Autoload
The most common reason Excel automatically forces open an old file is that it believes the application was shut down improperly, triggering the Document Recovery pane.
If Excel opens an old file and you see a panel on the left side of the screen labelled “Document Recovery”:
1. Do not simply close the spreadsheet. If you do, Excel will think the recovery is still pending and will reopen the file again next time.
2. Look at the files listed in the Document Recovery pane.
3. Click the small drop-down arrow next to each recovered file.
4. Select Close or Remove for every single file in the list.
5. Once the pane is completely empty, you can close Excel normally. The next time you launch the application, it will start cleanly.
How to Stop Excel from Opening Files in the Startup Folder
Excel has a hidden feature that forces it to automatically load any spreadsheet placed inside a specific system folder immediately upon launch. If a file is stuck in this folder, it will open every single time you start the app.
1. Open Microsoft Excel.
2. Click on File > Options.
3. In the left-hand pane, click on Advanced.
4. Scroll almost all the way to the bottom until you find the “General” section.
5. Look for a text box labelled At startup, open all files in:
6. If there is a file path listed in this box (e.g., C:\Users\Name\Desktop\StartupFiles), highlight the entire path and press Delete to clear the box completely.
7. Click OK.
If the box was already empty, you should manually check the default Office startup folder. Press Windows Key + R, type %appdata%\Microsoft\Excel\XLSTART, and press Enter. If there are any files inside that folder, delete them or move them elsewhere. Excel will now launch cleanly without loading old data.