Excel is opening every file because it’s loading everything from one or more startup folders. Remove the files and/or clear the alternate startup location to stop this.
On Excel for Mac, check both of these:
- Remove workbooks from the Excel Startup folder
- In Finder, type
startup in the Search box and press Return.
- In the results, double‑click the Startup folder, then double‑click the Excel folder.
- Move any files out of this Excel startup folder to another location.
- Restart Excel and confirm it no longer opens all those files.
- Clear any “At startup, open all files in” folder
- Open Excel.
- On the Excel menu, select Preferences.
- Under Authoring, select General.
- Find At startup, open all files in and clear any path shown there (or change it to an empty/unused folder).
- Close Preferences and restart Excel.
After these changes, Excel will only open its normal startup screen or a blank workbook instead of trying to open every file.
References: