A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
For Excel for Mac crashes that started recently when refreshing a PivotTable, the supported troubleshooting path is:
- Update Excel first Recent Excel for Mac builds have included crash fixes. In older release notes, Microsoft specifically lists “Fixed several crashes.”
- Check whether the issue is workbook-specific Since the crash happens in a regularly used spreadsheet when refreshing a PivotTable, verify whether the problem occurs only in that workbook or also in a new test workbook with a simple PivotTable.
- Reset Excel preferences
Corrupted Excel preferences are a documented cause of startup and stability problems on Mac.
- Quit all Office for Mac apps.
- In Finder, select Go > Home.
- Open Library. If hidden, hold Option while opening the Go menu.
- Open Preferences.
- Move
com.microsoft.Excel.plistto the desktop. - Start Excel and test.
- If the issue remains, quit Excel, restore the file, then continue.
- In Library > Preferences > Microsoft, move
com.microsoft.Excel.prefs.plistto the desktop and test again.
- Test in a new macOS user account A corrupted user profile is also a documented cause of Excel problems on Mac. If Excel works correctly in a new test account, the issue is likely tied to the existing macOS profile.
- Reinstall Office if needed If the problem continues after preference reset and user-profile testing, remove and reinstall Office. This addresses possible corrupted application files.
- If the crash began after a recent update, compare against known issue/fix status Microsoft maintains a current Excel for Mac known-issues page for recent crashes and workarounds. Also, historical release notes show crash fixes are often delivered in later updates.
Documented causes for Excel for Mac crashes include:
- corrupted Excel preferences
- background program interference
- corrupted application files
- corrupted user account profile