Office Apps Crashing

Fix Excel 2016 Crashes When Saving Workbooks with External Links

Olivia MillerOlivia Miller Nov 22, 2026 868 views

Question details

The user needs to stop Excel 2016 from crashing when saving a business-critical workbook after its external links are updated.

Fix Excel 2016 Crashes When Saving Workbooks with External Links
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a local test copy

Copy the workbook to a local folder, open the copy in Excel, and leave the shared workbook unchanged.

2
Test saving without updating links

If Excel prompts you to update links when opening the copy, choose Don't Update. Select File > Save and check whether Excel still crashes.

3
Inspect and update links

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.

4
Compare with another workbook

Open and save another workbook with external links. Note whether the crash affects only the business-critical file or multiple workbooks.

Test a Local Copy and Check External Links
Keep required links intact: Do not use Break Link on the production workbook: it replaces linked formulas with their current values. If you need to test it, use a disposable copy.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet data and formulas in WPS SpreadsheetUse a familiar interface for everyday spreadsheet workKeep a lightweight office suite available as an alternative
microsoft office alternative - wps office

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.