A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi Frustrated
Thank you for reaching out to Microsoft Q&A Forum and sharing your experience.
I understand how disruptive this can be, especially when Excel repeatedly opens hundreds of warning dialogs and won’t allow you to access Preferences or dismiss them efficiently.
In this situation, you can try the following steps.
First, force quit Excel completely:
- Press Command + Option + Esc on your keyboard, select Microsoft Excel, and choose Force Quit.
- If Excel does not close, open Activity Monitor (Spotlight > type Activity Monitor), select Microsoft Excel, then select X > Force Quit.
- If your Mac still cannot restart because Excel remains “busy”, press and hold the power (Touch ID) button for about 10 seconds to force a shutdown.
Next, try launching Excel in Safe mode:
- Make sure Excel is completely closed. Press and hold the Shift key, then while holding it, select the Excel icon to open the app. Continue holding Shift until the main Excel interface (template gallery or a blank workbook) fully loads.
Since PDFs are opening automatically in Excel, also check the Excel startup folder:
- In Finder, press Command + Shift + G, then paste the following path:
~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel/ - If any files are present, move them to the Trash.
Although you mentioned clearing containers, please also double-check the AutoRecovery folder to ensure no corrupted recovery files remain:
- In Finder, press Command + Shift + G, then paste:
~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/
After completing these steps, restart your Mac and then open Excel again to check whether the issue with returning windows still occurs.
Additionally, to help better understand the issue, could you please provide the following details:
- Is your Office content synced with OneDrive, and does pausing OneDrive sync change the behavior?
- Are any add‑ins or citation tools enabled in this file, and does Word close normally when you open a brand‑new blank document?
- Which versions of Word and macOS are you currently using?
Please know that while our initial response might not resolve the issue right away, your input is incredibly valuable. With a bit more detail, we’ll work together to find the best solution for you.
I am looking forward to seeing your response soon.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.