Excel Performance Problems

Fix Slow Excel VLOOKUP and Pivot Tables on a MacBook Air

Adam DavisAdam Davis Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create a test copy

In Excel, choose File > Save As and save a copy of the affected workbook under a different name.

2
Reduce the test data

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.

3
Repeat the slow actions

Edit a VLOOKUP formula and use PivotTable Analyze > Refresh on the PivotTable. Compare the response time with the original workbook.

4
Inspect the affected features

If the smaller copy is faster, review the original workbook's VLOOKUP ranges, PivotTable source data, and data connections for unnecessary rows or complexity.

Interpret the test: Removing data is a diagnostic step, not necessarily a permanent fix. Deleting source rows can change formula results and PivotTable totals in the test copy.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats such as XLSX and XLSWork with spreadsheet formulas and PivotTables in a lightweight Office suiteFree to download and use
microsoft office alternative - wps office

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.