Fix Corrupted Excel Workbooks & Missing Pivot Tables on Mac
Question details
The user needs to troubleshoot and resolve issues with Excel for Mac workbooks becoming corrupted, dropping pivot tables upon reopening, or failing when refreshing data.

- Product
- Microsoft Excel for Mac
- Device & OS
- Mac
- Scenario
- Opening, saving, or refreshing complex Excel workbooks that contain pivot tables and dynamic data formulas.
- Observed behavior
- Workbooks become corrupted, pivot tables disappear after the file is closed and reopened, and data refreshes fail when utilizing formulas like STOCKHISTORY.
Before attempting any troubleshooting steps, make a duplicate copy of your corrupted Excel workbook to ensure you do not permanently lose any existing data.
Isolate Problematic Elements and Test Cross-Platform
Identify the source of the corruption by systematically removing complex formulas and pivot tables, and try recovering the file using different versions of Excel.
Complex data connections and newer dynamic formulas (like STOCKHISTORY) can sometimes cause conflicts in Excel for Mac. Systematically isolating these elements can help you pinpoint the exact cause of the workbook corruption.
Create a brand new workbook and paste a small sample of your original source data as plain text to see if the issue persists in a clean environment.
In your duplicate workbook, delete recently added formulas, external data connections, and pivot tables one at a time. Save and reopen the file after each removal to check if stability returns.
Upload your corrupted workbook to OneDrive. Open your browser, navigate to Excel for the Web, and try opening the file there. Alternatively, try opening the file on a Windows desktop version of Excel, which may bypass Mac-specific bugs.
Open Excel, click on 'Help' in the top Apple menu bar, and select 'Check for Updates'. Install any pending updates, as Microsoft frequently patches known corruption issues.

Use Dynamic Array Functions as an Alternative
Replace unstable pivot tables with Dynamic Array functions to achieve the same summary layouts without requiring manual data refreshes.
Try WPS Office for Stable Spreadsheet Management on Mac
If you frequently encounter workbook corruption or missing pivot tables in Excel for Mac, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that provides a familiar interface for managing complex data without the common crashing issues.
- 1. Download the installer: Visit the official WPS Office website and download the Mac version.
- 2. Install WPS Office: Open the downloaded file and follow the on-screen instructions to install the software on your Mac.
- 3. Open your workbook: Launch WPS Spreadsheets and open your .xlsx file to manage your pivot tables and data securely.

Frequently Asked Questions
Why do my pivot tables disappear when I reopen my Excel file on Mac?
This usually happens due to file corruption, unsupported features in a specific Excel version, or conflicts with complex dynamic formulas (like STOCKHISTORY) failing to save correctly in the Mac environment.
Can I recover a corrupted Excel workbook on a Mac?
Yes. A common workaround is to upload the corrupted file to OneDrive and open it using Excel for the Web or a Windows PC. These platforms often process file structures differently and can bypass Mac-specific corruption bugs.
Are Dynamic Array functions a good replacement for pivot tables?
Yes. Dynamic array functions like UNIQUE, FILTER, and SORT can replicate many standard pivot table summaries. They offer the advantage of updating instantly without needing a manual data refresh, making them a stable alternative.




