Excel Performance Problems

Fix an Excel Workbook That Takes 15 Minutes to Save

Camila MilosovichCamila Milosovich Nov 18, 2026 869 views

Question details

The user needs to reduce the time an Excel workbook takes to save while retaining access to external data.

Fix an Excel Workbook That Takes 15 Minutes to Save
Product
Microsoft Excel
Device & OS
not provided
Scenario
A large workbook uses extensive formulas, including XLOOKUP references to another workbook.
Observed behavior
Saving can take 15 minutes, and inserting rows or changing link sources is also slow. A test saved instantly after the external links were broken.
Before you start

Identify the source workbook and the external formulas that need its data. Use File > Save As to create a test copy before changing or breaking links, since breaking links replaces linked formulas with their current values.

Solution 1Recommended

Replace External Workbook Links with a Power Query Import

Use this approach when many external XLOOKUP formulas are slowing the workbook but the source data must remain refreshable.

Import the source data once, then use a local table for lookups or perform suitable joins and transformations in Power Query. Test the results before removing the original links.

1
Import the source data

In Excel, select Data > Get Data > From File > From Excel Workbook, choose the source file, and select the sheet or table containing the data.

2
Load a local table

In the Navigator, select Transform Data if changes are needed, then use Close & Load to load the result into an Excel table.

3
Replace external formulas

Edit the XLOOKUP formulas to reference the imported table instead of the external workbook. For suitable matching and calculations, use Merge Queries or other transformations in the Power Query Editor instead.

4
Refresh and test

Select Data > Refresh All, compare the results with the original workbook, and time a save. Review any remaining links under Data > Workbook Links or Data > Edit Links, depending on your Excel version.

Replace External Workbook Links with a Power Query Import
Refresh the imported data: Power Query imports do not necessarily update immediately when the source changes. Use Data > Refresh All when you need the latest available source data.
Free Microsoft Office alternative

Work with Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. Its Excel format support makes it easier to move existing spreadsheets, although switching apps does not directly fix Excel's external-link performance.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet formulas and tables in a familiar interfaceUse a free, lightweight Office alternativeMove between common Microsoft Office document formats
microsoft office alternative - wps office

Frequently Asked Questions

Why did my workbook save quickly after I broke its links?

The result suggests that external links were contributing to the delay. Breaking a link replaces its linked formulas with their current values, so those formulas no longer update from the source workbook.

Where can I find external workbook links in Excel?

Open the Data tab and look for Workbook Links or Edit Links, depending on your Excel version. Review each source before changing or breaking a link.

Can I keep external data up to date without thousands of workbook links?

You can import the source with Data > Get Data > From File > From Excel Workbook, then use the loaded table for local lookups. Select Data > Refresh All to update the imported data when needed.

Will Power Query automatically make every workbook faster?

Not necessarily. Performance depends on the source, query, formulas, and workbook size. Test the imported data and compare save and refresh times before replacing the original setup.