Fix Excel for Mac Not Opening Files After macOS Big Sur Upgrade
Question details
Users are unable to open files, or they experience UI glitches in Excel after updating their Mac operating system to Big Sur.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS Big Sur
- Scenario
- Attempting to launch the Excel application or open existing spreadsheet files following a macOS Big Sur system update.
- Observed behavior
- Excel windows may open off-screen, display only the top ribbon with no workspace, fail to open selected files, or have menu commands disabled even after a clean reinstallation.
Ensure your Mac is connected to the internet to download necessary updates, and save any open work in other applications before restarting your system in Safe Mode.
Update Microsoft 365 and Reset the Excel Container
Installing the latest Office updates and clearing the Excel cache container usually resolves compatibility bugs introduced by macOS Big Sur.
macOS system updates often require software vendors to release compatibility patches. If your Microsoft 365 installation is outdated, it may struggle to render correctly on Big Sur. Resetting the container folder forces Excel to rebuild its preferences.
Open a working Office application like Word. From the top menu bar, select 'Help' > 'Check for Updates' and install any available updates for Microsoft 365.
Ensure that Microsoft Excel is completely quit. You can do this by right-clicking the Excel icon in the Dock and selecting 'Quit'.
Open Finder. In the top menu bar, click 'Go' > 'Go to Folder', type '~/Library/Containers' in the search box, and press Return.
Locate the folder named 'Microsoft Excel' within the Containers directory. Drag this folder to your Desktop to remove the cached files.
Launch Microsoft Excel again to allow it to generate fresh preference files and test if you can open your spreadsheets.
Test in Safe Mode and Validate Fonts
Conflicting background software or corrupted system fonts can cause Excel UI elements to fail or windows to render off-screen.
Try WPS Office as a Seamless Excel Alternative for Mac
If Microsoft Excel continues to crash, display off-screen, or show UI errors on macOS Big Sur, WPS Office provides a lightweight, highly compatible, and completely free alternative. Experience seamless spreadsheet editing without the heavy system requirements.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office version for Mac.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open or drag-and-drop your existing .xlsx files.
- 3. Edit Seamlessly: Continue your work with full formula and formatting compatibility.
Frequently Asked Questions
Why does my Excel window only show the top ribbon on macOS Big Sur?
This is a known rendering bug caused by compatibility issues between older Microsoft 365 versions and the macOS Big Sur visual interface. Updating your Office suite to the latest version usually restores the full workspace view.
Will clearing the Microsoft Excel container folder delete my saved spreadsheets?
No. The container folder (located in ~/Library/Containers) only stores application cache, window layouts, and UI preferences. Your personal .xlsx files saved in Documents, Desktop, or OneDrive remain completely safe.
How do I know if a corrupt font is causing Excel to crash on my Mac?
You can isolate font issues by booting your Mac into Safe Mode, which disables third-party fonts and background apps. If Excel opens files normally in Safe Mode but fails during a normal boot, a damaged or duplicated system font is likely the culprit.
What should I do if Word and PowerPoint also fail to open files?
If multiple Office applications are experiencing issues after the Big Sur upgrade, it indicates a suite-wide compatibility problem. You should run the Microsoft AutoUpdate tool to update all apps simultaneously, or reinstall the entire Microsoft 365 suite if updates do not fix it.
