'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Stop Excel Asking to Save Every New Blank Workbook
Question details
The user wants to prevent Excel from automatically prompting them to save a new, unmodified blank workbook immediately after launching the application.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Launching Microsoft Excel and opening a new blank workbook.
- Observed behavior
- Excel unexpectedly prompts the user to save the new blank workbook upon startup, typically caused by startup folders, templates, or application settings opening files automatically in the background.
Before troubleshooting Excel startup settings, save your current work and close all active Microsoft Office applications. If you plan to modify registry settings, be sure to create a system or registry backup first.
Clear the 'At Startup' Folder Setting
Disable the setting that forces Excel to open files from a specific folder whenever the application launches.
Excel has a built-in feature that automatically opens any files placed in a designated startup folder. If a template or macro file is specified here, it can trigger the save prompt for blank workbooks.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' from the bottom of the menu.
In the Excel Options dialog box, click on 'Advanced' in the left-hand navigation pane.
Scroll down to the 'General' section. Locate the text box next to 'At startup, open all files in:' and delete any folder paths listed there. Click 'OK' to save the changes.
Empty the XLSTART Folders
Locate and temporarily remove templates or auto-recovery files in the XLSTART directories that might be causing hidden modifications.
Reset Excel Settings via Registry Editor
If the issue persists, renaming the Office registry key will force Excel to rebuild its default settings on the next launch.
Switch to WPS Office for a Hassle-Free Spreadsheet Experience
If troubleshooting Excel's registry and startup folders feels too risky or time-consuming, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for all your spreadsheet tasks without the startup glitches.
- 1. Download and Install: Visit the official WPS Office website to download the free installation package.
- 2. Set as Default: During or after installation, choose to set WPS Spreadsheet as your default program for opening Excel files.
- 3. Open Your Spreadsheets Instantly: Double-click any existing workbook to experience lightning-fast load times without unnecessary save prompts.
Frequently Asked Questions
Why does Excel ask to save a blank workbook immediately after opening it?
This typically occurs because a macro, add-in, or auto-opening template located in the XLSTART folder modifies the blank workbook in the background as soon as it opens, tricking Excel into thinking there are unsaved changes.
Where is the XLSTART folder located?
The primary location is usually C:\Users\<UserName>\AppData\Roaming\Microsoft\Excel\XLSTART. Depending on your installation, it may also exist in C:\Program Files\Microsoft Office\root\Office16\XLSTART.
Is it safe to delete files in the XLSTART folder?
Yes, but it is highly recommended to temporarily move them to another location first. If removing them fixes the Excel startup issue and you don't miss any customized templates, you can safely delete the moved files.
What does the 'At startup, open all files in' setting do?
This setting instructs Excel to automatically load every file stored in the specified directory whenever the application starts. If incorrect or unnecessary paths are added here, it can lead to performance issues or unwanted save prompts.
