Fix Excel 2016 Crashes When Saving Workbooks with External Links
Question details
The user needs to stop Excel 2016 from crashing when saving a business-critical workbook after its external links are updated.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- A large shared workbook uses data linked from external sources and cannot easily be recreated.
- Observed behavior
- Excel crashes when the workbook is saved after linked data is updated.
In Excel, open File > Account > About Excel and record the Office version and build. Identify the linked source files and ask other users whether the crash affects the same workbook or other workbooks.
Test a Local Copy and Check External Links
Use a local test copy to determine whether the crash is tied to the workbook, its links, or its shared location.
Copy the workbook to a local folder, open the copy in Excel, and leave the shared workbook unchanged.
If Excel prompts you to update links when opening the copy, choose Don't Update. Select File > Save and check whether Excel still crashes.
Select Data > Edit Links, review the listed sources, and use Update Values or Change Source as appropriate. Save after testing links individually to identify a source associated with the crash.
Open and save another workbook with external links. Note whether the crash affects only the business-critical file or multiple workbooks.

Run an Online Repair of Office 2016
Repair the Office installation if the crash affects multiple workbooks or persists after checking links.
Check for Workbook Corruption and Office Updates
Use this approach if the crash is limited to one workbook or began after an Office update.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format support can make migration straightforward, although it does not repair an Excel installation; test complex external links on a copy before switching workflows.

Frequently Asked Questions
How can I tell whether an external link causes the crash?
Open a local copy without updating links and try saving it. Then use Data > Edit Links to update sources individually and save after each test.
What happens if I break an external link in Excel?
Using Break Link in Data > Edit Links replaces formulas linked to that source with their current values. Test this only on a disposable copy if the links are needed.
What should I do if the Office Modify button is disabled?
Try selecting Office under Control Panel > Programs > Programs and Features and check whether Change is available. If it is unavailable on a managed computer, ask your IT administrator about repair permissions and the Office installation method.
Where can I find my Excel 2016 version and build?
In Excel, select File > Account > About Excel. Record the version and build when reporting the crash.
Can WPS Office fix the Excel 2016 crash?
WPS Office does not repair Microsoft Excel, but WPS Spreadsheet can open Excel files as an alternative. Test external links and other critical workbook features on a copy before using it for production.




