Excel Find and Replace: Why Update Values Opens

Excel Find and Replace does not normally open an “Update Values” prompt by itself. If that prompt appears while you are searching or replacing, Excel is usually trying to locate or refresh an external workbook link referenced in the file; check the link source before updating it, and choose not to update if you cannot verify the source.

What the “Update Values” prompt means

A dialog titled “Update Values: [workbook name]” generally means Excel needs a source workbook used by a link in the current workbook. The source may have been moved, renamed, deleted, or stored on a network location that is currently unavailable. Excel may show a file picker so you can point it to the source file. In other cases, Excel displays a message asking whether to update links, with options such as Update and Don’t Update.

This is different from the Find and Replace window. In Excel for Microsoft 365 on Windows, Ctrl+H opens Find and Replace; the ribbon route is Home > Find & Select > Replace. Those controls search or change worksheet content. They do not themselves require you to choose an external file. However, a search or replacement that touches a linked formula can lead Excel to resolve the link, which is why the two events can seem connected.

An external link is a reference from one workbook to another. It can point to a cell or range in a different Excel file. For example, a formula might refer to a workbook named SalesData.xlsx in a particular folder. If that workbook is no longer at the recorded location, Excel cannot retrieve its current value until the source is found or the link is otherwise handled.

Why it can appear during Find and Replace

Find and Replace can search either displayed values or formula text. If the search is set to look in formulas and the replacement changes part of an external reference, Excel may need to evaluate the edited formula or locate the referenced workbook. A replacement that changes a folder name, workbook name, sheet name, or other text forming part of a link can also affect where the formula points. The prompt may then appear during the operation or when Excel recalculates.

It can also be a coincidence. Excel may ask about links when you open a workbook, recalculate it, or perform another action that requires linked data. If Find and Replace happens to be the action you noticed just before the message, that does not prove the search caused it. A workbook can contain links in formulas, defined names, charts, or other features even when the active worksheet does not visibly show an external reference.

Find and Replace settings can persist between uses, so check them before changing anything. The “Look in” setting determines whether Excel searches formula text or cell values. “Within” determines whether the search applies to the current sheet or the whole workbook. A broad Replace All with the wrong scope can change many cells, including formula text that was not meant to be edited.

How to handle the prompt safely

First, pause rather than choosing a file at random. If the source workbook is familiar and you know its correct current location, locating it can restore the link. If you do not recognize the workbook name or path, do not update it until you have checked with the file owner or confirmed the source. A missing source is not a reason to browse to an unrelated file with a similar name.

Note the workbook name shown in the prompt and, if available, the original folder path.
Choose Don’t Update or cancel the file picker if you cannot verify the source. This lets you continue without retrieving the latest linked values; it does not necessarily remove the links.
If you recognize the source, use the prompt’s browse option to select the correct workbook, then review the results before saving.
After the prompt is resolved, inspect the Find and Replace settings and use Find Next before Replace or Replace All.
Save a separate copy before making a large replacement, particularly if formulas or the whole workbook are in scope.

Not updating usually means Excel retains the values already saved in the workbook rather than fetching current values from the linked file. Those saved values may be out of date. Updating can bring in newer source data, but it can also produce errors if the source is unavailable or if the source workbook is not the one you intended. The dialog is about retrieving linked workbook data; it is not a request to enable macros.

Check which cells Find and Replace will affect

On Windows, open Find and Replace with Ctrl+H, then review the options before using Replace All. Set “Within” to Sheet if you only intend to change the current sheet, or Workbook if the replacement really should apply across all sheets. Set “Look in” deliberately. Searching formulas is useful for locating formula text, but replacing formula text can alter calculations and references. Searching values is more appropriate when you mean to find visible cell contents.

For a safer pass, enter the search text and choose Find All or Find Next first. Check the matching cells and their formulas in the formula bar. If you are replacing a short string such as a year, a sheet-name fragment, or a folder name, inspect several matches: the same characters can appear in labels, dates, identifiers, and formulas for unrelated reasons. Use Replace on individual matches when the consequences are unclear.

On Mac, use Excel’s Find and Replace controls from the ribbon or the Edit menu; keyboard shortcuts can vary with keyboard settings, so the menu route is a dependable way to open the dialog. Excel for the web has a ribbon-based Find and Replace control as well. Browser shortcuts can be intercepted by the browser, and link-management options may differ from the Windows desktop version, so use the desktop app when you need to inspect or repair workbook links in detail.

Find and manage the external workbook link

In Excel for Microsoft 365 on Windows, check the Data tab for Workbook Links. The pane lists links Excel recognizes and can provide information about their source and available actions. If the source was simply moved, correcting the source location may be the cleanest fix. If the workbook is intentionally unavailable, you can leave the link unchanged and work with the last saved values, while remembering that they may not be current.

Workbook link controls and labels can vary by Excel build and by the type of link. If you cannot find Workbook Links, check the Data tab and Excel’s help for your installed version. Some older desktop versions use an Edit Links command instead. A workbook may also contain external connections that are managed separately from ordinary formula links, so an empty link list does not always prove that no external data connection exists.

Do not use Break Links simply to silence a prompt unless you understand the effect. Breaking a workbook link commonly replaces linked formulas with their current values. That stops those formulas from updating from the source, and the original formula relationship may be difficult to reconstruct. Make a backup first and confirm that fixed values are acceptable for the workbook’s purpose.

Common causes and mistakes

The source file moved: A link still points to the old folder or drive. Restore the file to the expected location or update the link to its verified new location.
A shared drive is unavailable: A network folder or cloud-synced location may not be accessible at the moment. Confirm connectivity and permissions before changing the link.
The workbook was copied: A copied workbook can retain links to the original author’s files. Check whether those sources are intended dependencies or leftover references.
Replace All changes formula text: A broad replacement can modify references or formula constants as well as ordinary text. Review the match scope and make a backup first.
The prompt is mistaken for a security warning: Update Values concerns linked data, not macro execution. Still, do not retrieve data from an unknown source just because Excel offers to do so.

Another common misconception is that closing the prompt deletes the external link. Usually it only declines or cancels that particular update attempt. The link can remain in the workbook and trigger another prompt later, depending on Excel’s link settings and what action requires the source. To stop recurring prompts, identify and deliberately repair, remove, or retain the link rather than repeatedly dismissing the message without checking it.

When to update, keep, or remove a link

Update a link when you need current information, trust the source, and have confirmed that the selected file is the correct one. Keeping the link without updating may be suitable when you only need to review the workbook’s previously saved results, but those results should not be treated as current unless you know when they were last refreshed.

Remove or break a link only when the workbook should no longer depend on that source. Before doing so, save a copy and decide whether you need formulas to continue updating or whether fixed values are acceptable. If the workbook supports reporting, forecasting, or a recurring process, ask its owner how the dependency is meant to work. A broken reference can affect other users who expect the workbook to refresh.

If the prompt appears after a replacement, use Undo immediately if the replacement has changed unintended cells and the action is still undoable. Ctrl+Z is the Windows shortcut; on Mac, use Command+Z. Undoing the cell replacement does not necessarily undo a link update or restore a source file, so inspect the workbook afterward. If the results are uncertain, close without saving and reopen your backup.

Frequently Asked Questions

Why does Excel ask me to update values when I press Ctrl+H?
Ctrl+H opens Find and Replace; it does not normally request linked data on its own. The workbook may contain an external link that Excel needs to resolve when a formula is searched, changed, or recalculated, or the prompt may be appearing for an unrelated reason such as opening the workbook.

Will choosing Don’t Update stop the links from working?
It declines that update attempt, but it generally does not remove the link. Excel may continue to show saved values, which can be stale, and may ask again when a later action needs the source.

Is it safe to click Update Values?
It is appropriate when you recognize and trust the source workbook and have verified that it is the intended file. If you do not recognize the name or location, cancel or choose not to update until you can confirm the source.

Can Find and Replace change formulas?
Yes. When the search is set to look in formulas, a replacement can edit formula text, including references. Check the “Look in” and “Within” settings, inspect matches, and save a copy before a broad replacement.

How do I stop the Update Values prompt from returning?
Find the workbook link or external connection and decide whether to correct its source, keep it, or remove it. Dismissing the prompt does not usually remove the underlying reference. In Microsoft 365 for Windows, start by checking Data > Workbook Links.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.