'%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 Fix Excel Workbook Closes and Restarts in Safe Mode
Question details
An Excel workbook stored on OneDrive unexpectedly closes and then automatically reopens in Safe Mode, resulting in disabled macros and command buttons.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Working on a large Excel workbook that utilizes macros and automatic currency-exchange formulas while syncing to OneDrive.
- Observed behavior
- The Excel application crashes unexpectedly and automatically restarts in Safe Mode, which disables necessary add-ins, macros, and buttons.
Before proceeding, check your internet connection and ensure that the OneDrive icon on your taskbar shows your files are completely synchronized and up to date.
Resolve OneDrive Sync and Formula Conflicts
Address environmental and file-specific triggers like incomplete OneDrive syncs, large file sizes, or resource-heavy automatic formulas.
Complex workbooks that continuously attempt to pull live data or sync large amounts of data to OneDrive over unstable connections can overload Excel, causing it to crash and reboot into Safe Mode.
Click the OneDrive cloud icon on your Windows taskbar. Ensure the status reads 'Up to date' and no sync errors are displayed.
Open your workbook and remove unnecessary formatting, hidden sheets, or unused raw data to decrease the overall file size and reduce memory usage.
Temporarily remove or disable automatic currency-exchange formulas and live data connections to test if the workbook remains stable without them.
Manually Start Excel in Safe Mode
Manually launch Excel in Safe Mode to determine if a faulty add-in or corrupted macro is responsible for the crashes.
Repair the Microsoft Office Installation
Use the Windows Control Panel to repair potentially corrupted Office program files that are causing the restart loop.
Switch to WPS Office for a Stable Spreadsheet Experience
If Microsoft Excel continues to crash or repeatedly force Safe Mode, consider switching to WPS Office. It is a highly stable, lightweight alternative that handles large data sets efficiently and prevents resource-heavy workbook crashes.
- 1. Download the installer: Visit the official WPS website and download the free WPS Office installer.
- 2. Install the software: Run the installer and follow the quick setup instructions to install WPS Spreadsheets.
- 3. Open your workbook: Launch WPS Spreadsheets and open your .xlsx file to continue your work without unexpected crashes.
Frequently Asked Questions
Why does my Excel file keep opening in Safe Mode automatically?
Excel automatically enters Safe Mode when it detects a critical error during startup or operation. This is usually triggered by corrupted add-ins, conflicting macros, incomplete OneDrive syncing, or damaged Office installation files.
How do I get Excel out of Safe Mode?
To exit Safe Mode, completely close the Excel application. Reopen Excel normally from your Start menu or taskbar without holding the Ctrl key. If it continues to open in Safe Mode, you will need to disable active add-ins or repair your Office installation.
Can I run my macros while Excel is in Safe Mode?
No, Safe Mode intentionally restricts functionality to isolate problems. It disables all macros, COM add-ins, and custom toolbars to provide a clean, stable environment for troubleshooting.
Will reducing my workbook size stop Excel from crashing?
Yes, overly large workbooks with excessive formulas, conditional formatting, or hidden data can overload your system's memory, leading to application crashes. Optimizing the file by removing unused data can significantly improve stability.
