Excel keeps asking to update links — how to stop the popup for good
Every time you open the file, Excel asks whether you want to update or not update links. You click a button, get into your spreadsheet, and then the exact same thing happens tomorrow. This isn't a bug — it means your file still contains at least one external link, and the only way to stop the prompt is to find and remove what's causing it.
The two ways to remove the link
The prompt stops for good only when you remove the external link itself — not by clicking "Don't Update," and not by suppressing the popup in File > Options > Advanced (that leaves the reference in place, potentially showing a stale number). Once you've found the link, you have a choice:
- Break the link — go to Data > Edit Links and click "Break Link." Excel replaces the formula with its current value as a plain number. The live connection disappears and the prompt stops. This is the right move when you don't need the data to refresh from the other file anymore.
- Update the source — if the other file still exists but moved to a new location, use "Change Source" in the Edit Links dialog to point Excel at the new path. The link stays live and the values will refresh correctly going forward.
If "Break Link" is greyed out, a sheet is protected. Go to Review > Unprotect Sheet first, then try again.
Where links hide — it's not always a formula
Most people go straight to the formula bar and search for [ (the character that marks an external reference like =[OtherFile.xlsx]Sheet1!A1). That finds a lot of them, but links can also live in places that don't show up in a normal formula search:
- Named ranges — go to Formulas > Name Manager and look for any name whose "Refers to" column contains a file path in brackets.
- Charts — chart data series and axis labels can reference cells in external workbooks. You have to click into the chart and check the formula bar for each series.
- Conditional formatting rules — a formatting rule's condition can reference a cell in another file. Go to Home > Conditional Formatting > Manage Rules, and look at what each rule's formula points to.
- Data validation dropdowns — if a dropdown's list source points to a named range in another workbook, that's an external link too.
This is why people sometimes delete every formula they can find, break every link in the Edit Links dialog, and the popup still comes back. The link survived somewhere they didn't think to look.
Why the prompt keeps coming back
The "Update / Don't Update" dialog appears because your workbook has a formula — or a named range, chart, or data validation rule — that references a cell in a different Excel file. Every time you open the workbook, Excel checks to see whether that other file is available and asks what you want to do with it. Clicking "Don't Update" doesn't remove the link — it just defers the question until next time. That's why the actual fix is removing the link itself.
Find every external link in your file — including the hidden ones
If you've already searched formulas and broken the links you could find but the prompt keeps coming back, there's likely a link buried in a named range, chart, or formatting rule. Upload your file to the tool at the top of this page and it will find every external reference — in formulas, names, charts, and validation rules — and give you a plain list of each one with its location.