Fix an Excel Workbook That Takes 15 Minutes to Save
Question details
The user needs to reduce the time an Excel workbook takes to save while retaining access to external data.

- 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.
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.
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.
In Excel, select Data > Get Data > From File > From Excel Workbook, choose the source file, and select the sheet or table containing the data.
In the Navigator, select Transform Data if changes are needed, then use Close & Load to load the result into an Excel table.
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.
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.

Reduce Formula and Object Overhead in the Workbook
Use these checks alongside link changes if saving or editing remains slow.
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.

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.




