Fix Excel 365 External Links Recalculating After Do Not Update
Question details
The user needs to prevent or troubleshoot recalculation of inaccessible external links in an Excel 365 workbook.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Opening a workbook with external links and choosing not to update them.
- Observed behavior
- Excel recalculates formulas involving inaccessible external links, resulting in #REF! errors.
Identify the affected workbook and, if possible, the files it links to. Note whether the source files are stored locally or in a cloud location and whether their paths or availability have recently changed.
Open the workbook with manual calculation enabled
Use manual calculation as a temporary workaround to reduce unwanted recalculation when opening the affected file.
Choosing not to update external links and controlling formula calculation are separate actions. Manual calculation may help avoid the reported errors, but it does not repair broken links or make source files available.
Close open workbooks, start Excel, and open a blank workbook before opening the affected file.
Go to Formulas > Calculation Options and select Manual. If available, also check File > Options > Formulas and clear Recalculate workbook before saving.
Use File > Open to open the affected workbook. If prompted to update external links, choose Don't Update.
Review the affected cells without selecting Calculate Now or pressing F9. After closing the affected workbook, restore Automatic under Formulas > Calculation Options if you normally use automatic calculation.

Inspect workbook links and restore access to source files
Use this approach to identify unavailable sources or changed paths that may be contributing to #REF! errors.
Collect Excel version and error details for further investigation
Gather diagnostic information if manual calculation is the only workaround or the link checks do not resolve the issue.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open compatible spreadsheets in WPS Spreadsheets for an easier transition, while testing external links and formulas before relying on their results.

Frequently Asked Questions
Why can Excel recalculate after I choose Don't Update?
The external-link update prompt and Excel's formula calculation setting control different operations. Check Formulas > Calculation Options to see whether calculation is set to Automatic or Manual.
How do I open the workbook without automatically recalculating it?
Start Excel with a blank workbook, select Formulas > Calculation Options > Manual, and then open the affected file through File > Open. Choose Don't Update if prompted, and avoid manual recalculation while checking the workbook.
Where can I find the external files linked to my workbook?
Select Data > Workbook Links or Data > Edit Links, depending on your Excel version. You can also search formulas for a source file name or an opening bracket ([) and inspect Formulas > Name Manager.
Will breaking the links fix the #REF! errors?
Not necessarily. Break Link replaces linked formulas with their current values, which may already contain errors. First check source availability and use Change Source if a file has moved.
What information should I provide when asking for support?
Capture File > Account > Product Information, screenshots of the errors, and details about affected source files. Include any recent Excel updates or cloud-storage changes.




