Fix Slow Excel VLOOKUP and Pivot Tables on a MacBook Air
Question details
The user needs to improve Excel performance when editing VLOOKUP formulas or refreshing a PivotTable.
- Product
- Microsoft Excel 16.33 for Mac
- Device & OS
- 2015 MacBook Air with 8 GB of memory; macOS version not provided
- Scenario
- Editing a VLOOKUP table or refreshing a PivotTable in Excel.
- Observed behavior
- Excel becomes unresponsive despite reinstalling and updating Office, freeing disk space, and closing other applications.
Identify the affected workbook and note whether the delay occurs during VLOOKUP edits, PivotTable refreshes, or both. Open another workbook to check whether the slowdown is limited to one file.
Test the Workbook With Less Data
Use this test to determine whether the workbook's data volume, formulas, or PivotTable source is contributing to the slowdown.
In Excel, choose File > Save As and save a copy of the affected workbook under a different name.
In the copy, select and delete a portion of the source data that is not needed for the test. Check that the VLOOKUP and PivotTable source ranges still include the remaining data.
Edit a VLOOKUP formula and use PivotTable Analyze > Refresh on the PivotTable. Compare the response time with the original workbook.
If the smaller copy is faster, review the original workbook's VLOOKUP ranges, PivotTable source data, and data connections for unnecessary rows or complexity.
Update macOS and Restart the MacBook Air
Check for available macOS updates and retest Excel after a restart.
Check External Displays and Other Hardware Factors
Use this check if Excel remains slow after the workbook and macOS tests.
Try WPS Spreadsheets as an Excel Alternative on Mac
WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to explore a possible migration path; it does not repair Microsoft Excel's performance problem.

Frequently Asked Questions
How can I tell whether the slowdown is specific to one workbook?
Open a different workbook in Excel and try a similar edit or PivotTable refresh. If only the original file is slow, investigate its formulas, source data, PivotTables, and connections.
Why test a smaller copy of the workbook?
Reducing data in a copy helps reveal whether the amount of data or related calculations is contributing to the delay. Use File > Save As first so the original remains unchanged.
Could an external monitor affect Excel performance?
It may be worth testing as a hardware factor. Disconnect external displays, use the MacBook's built-in screen, and repeat the same Excel action to compare performance.
Where can I check for macOS updates on this MacBook Air?
Open Apple menu > System Preferences > Software Update and check for updates compatible with the Mac. Restart after installing an update, then retest the workbook.




