Calculation Issues

Fix Excel 365 External Links Recalculating After Do Not Update

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

The user needs to prevent or troubleshoot recalculation of inaccessible external links in an Excel 365 workbook.

Fix Excel 365 External Links Recalculating After Do Not Update
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.
Before you start

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.

Solution 1Recommended

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.

1
Start with a blank workbook

Close open workbooks, start Excel, and open a blank workbook before opening the affected file.

2
Set calculation to manual

Go to Formulas > Calculation Options and select Manual. If available, also check File > Options > Formulas and clear Recalculate workbook before saving.

3
Open the affected file

Use File > Open to open the affected workbook. If prompted to update external links, choose Don't Update.

4
Check the displayed values

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.

Open the workbook with manual calculation enabled
Values may be out of date: Manual calculation can leave formula results unchanged until you recalculate. Review the workbook's results before relying on them.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesReview spreadsheet formulas and linked-workbook content in WPS SpreadsheetsUse a familiar interface that makes switching from Microsoft Office easierWork with a free, lightweight office suite
microsoft office alternative - wps office

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.