Excel crashes saving workbook with external links

Quick answer: Open the workbook, go to Data > Edit Links, break all external links. If Excel still crashes, disable 'Save AutoRecover info' temporarily during the save, then re-enable it.

What's actually happening here is that Excel gets caught in a deadlock when saving. The workbook contains external links referencing other workbooks. When you hit Save, Excel tries to update those links before writing the file. If the source workbook is also open, or if the path is broken, Excel can hang or crash — especially in Excel 2019 and Office 365 builds from 2022 onward. The underlying cause is a timing conflict: the link update process tries to lock the source workbook, which is already locked by the same instance of Excel. That circular dependency kills the save.

Step-by-step fix

1. First, save a backup copy. Excel might crash during this process. Use File > Save As to a different folder — this avoids the trigger path that causes the crash.
2. Open the workbook that crashes. When Excel prompts 'Update links?', click Don't Update. You don't want Excel to touch the external sources yet.
3. Go to Data > Queries & Connections > Edit Links. In Excel 365, it's under the Data tab Edit Links button (not Queries). The exact path: Data > Edit Links (in the Queries & Connections group).
4. Select each external link and click Break Link. Do this for every link in the list. Excel will warn you that breaking links replaces formulas with their current values. That's fine — you'll re-link later if needed.
5. Save the workbook. Hit Ctrl+S. It should save without crashing now.
6. If you actually need the links, re-create them. After the save, undo the break (Ctrl+Z) or re-link manually. The trick: save once without links, then restore links. That initial save breaks the crash trigger.

Alternative fixes when the main one fails

If step 3 crashes Excel before you can break links, try these:

• Disable AutoRecover temporarily. File > Options > Save > uncheck 'Save AutoRecover information every X minutes'. Crash often happens because AutoRecover tries to save while the update chain is mid-operation. Once you've saved manually, re-enable AutoRecover.
• Open the workbook in safe mode. Hold Ctrl while opening Excel, then open the file. Safe mode disables add-ins that might interfere with link updates. Run excel /safe from Run (Win+R).
• Use Excel's Open and Repair. File > Open > select the file > click the dropdown arrow next to Open > Open and Repair. This can strip partial link corruption.
• Manually edit the file as a zip. Rename the .xlsx to .zip, extract, open xl/links.xml and delete all <externalLink> entries. Re-zip and rename back to .xlsx. This removes links without opening Excel. Works on Windows 10/11 with any unzip tool.

Prevention tip

Stop Excel from automatically updating external links on save. Go to File > Options > Advanced > General > 'Update links to other documents' > set it to Never. This won't break existing links — Excel will still show their cached values, but won't try to fetch new data on every save. Update links manually only when needed via Data > Edit Links > Update Values. That single change eliminates 90% of save-related crashes with external references.

Also, avoid linking to workbooks that are stored on network drives with intermittent connectivity. If you can, copy the source data to a local path or use a database connection via Power Query instead of direct cell references. The cell-link approach is fragile — Excel locks the source file, and any network hiccup causes the crash on save.

One more thing: if you're on Office 365, check which build you're on. Versions 2206 through 2302 (released 2022-2023) had a known bug where saving workbooks with external links to closed files would crash. Microsoft fixed it in build 2304 (April 2023). Update Office manually: File > Account > Update Options > Update Now. If you can't update, the zip-edit trick is your fastest out.