How to Fix Excel Opening Random Workbooks in an Endless Loop on Mac
Question details
Excel repeatedly opens multiple random workbooks automatically upon startup in an endless loop, rendering the application unusable.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Launching the Microsoft Excel application on a Mac computer.
- Observed behavior
- Instead of opening a single blank workbook or the home screen, Excel enters an endless loop of opening random workbooks. Force quitting the application provides only a temporary fix.
Ensure you have completely force-quit Excel before proceeding. Press Option + Command + Esc on your Mac, select Microsoft Excel, and click Force Quit to stop the active endless loop.
Clear the Excel Startup Folder and Reset Application Cache
By isolating any problematic auto-start workbooks and moving the Microsoft Excel container folder to your desktop, you can clear corrupted cache files and resolve the endless startup loop.
This process safely resets the Excel application settings without deleting your personal spreadsheets. The macOS Library folder contains temporary application states that often cause these recurring loops.
Open Finder, click 'Go' in the top Apple menu bar, press and hold down the 'Option' key on your keyboard, and select 'Library' from the dropdown menu that appears.
Navigate into the 'Containers' folder. Look for a folder named 'Microsoft Excel' (note: on older macOS versions, this may be named 'com.microsoft.Excel').
Click and drag the 'Microsoft Excel' folder to your Mac's desktop. This forces Excel to rebuild a clean cache and drops the corrupted startup state.
Open Microsoft Excel again. If the application starts normally without the workbook loop, the issue is resolved, and you can safely move the folder on your desktop to the Trash.
Switch to WPS Office for a Stable Mac Spreadsheet Experience
If Excel continues to crash or get stuck in frustrating startup loops on your Mac, consider trying WPS Office. It provides a highly stable, lightweight environment that fully supports all your spreadsheet needs without the endless glitches.
Frequently Asked Questions
Will moving the Microsoft Excel container folder delete my saved spreadsheets?
No, the container folder only holds application preferences, cache, and temporary startup states. Your actual workbooks and documents saved on your Mac will remain untouched and completely safe.
Why does Excel automatically open random files on a Mac?
Excel may automatically open files if they are accidentally placed in the application's designated 'Startup' folder, or if macOS is configured to restore previous application windows from your last session upon restarting the computer.
What should I do if the endless loop happens again after clearing the cache?
If the issue returns, open Excel, go to 'Excel' > 'Preferences' > 'General', and ensure the 'At startup, open all files in' text box is completely blank. If it continues, you may need to update your macOS or cleanly reinstall the Microsoft Office suite.
