Formula Errors

How to Fix Excel Repeatedly Displaying the Update Values Dialog

Natalie Taylor Oct 9, 2026 871 views

Question details

The user needs to resolve an issue where the Update Values dialog box repeatedly pops up in Excel, typically when working with or copying formulas linked to external workbooks.

How to Fix Excel Repeatedly Displaying the Update Values Dialog

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying and pasting large ranges of cells that contain formulas linked to another workbook, or running an automation process.
Observed behavior: The Update Values dialog continuously prompts the user to locate or update the linked source files, interrupting the workflow and preventing the paste or macro from completing smoothly.

Before you start

Before modifying your formula links, save a backup copy of your current workbook. Ensure that any source workbooks you are trying to link to have not been moved, renamed, or deleted from their original folder locations.

Solution 1Recommended

Identify and Correct External Workbook References

Locate broken external links that are triggering the Update Values prompt and update them to the correct file path.

When Excel cannot find the external workbook referenced in a copied formula, it prompts you to locate it manually. Fixing these broken links will permanently stop the dialog from appearing during calculations or copy-paste operations.

Open the Edit Links dialog

Navigate to the 'Data' tab on the Excel ribbon and click on 'Edit Links' in the Queries & Connections group.

Check link status

In the Edit Links window, click 'Check Status' to identify which external workbook connections are broken or unavailable.

Update or change the source

Select the broken link, click 'Change Source', and browse your computer to select the correct, currently available source workbook.

Identify and Correct External Workbook References

Check Worksheet Naming Conventions: Pay special attention to worksheet names, especially those beginning with numbers. If the source worksheet name starts with a number or contains spaces, ensure the formula wraps the sheet name in single quotes (e.g., ='[Budget.xlsx]1st Quarter'!A1).

Solution 2

Paste as Values to Avoid Copying External Links

If you only need the calculated data and not the live formulas, pasting as values prevents Excel from attempting to link to external files.

Solution 3

Temporarily Disable Alerts Using VBA

For users experiencing this dialog interruption during macro execution, you can suppress Excel alerts programmatically.

Manage External Links Easily with WPS Spreadsheet

WPS Spreadsheet offers a highly compatible and intuitive interface for managing external workbook references. It allows you to efficiently track, update, or break external links without being bombarded by constant pop-up dialogs during your daily workflow.

1. Open WPS Spreadsheet: Launch WPS Office and open your workbook containing the copied data and external links.
2. Access the Data Tab: Navigate to the 'Data' tab located on the top ribbon menu.
3. Click on Edit Links: Select the 'Edit Links' option to view all external workbook references currently tied to your document.
4. Resolve the Links: Choose the problematic link from the list and select 'Update Values', 'Change Source', or 'Break Link' to permanently resolve the missing file prompts.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats, formulas, and external link structures.Clear, user-friendly Edit Links tool to easily manage and repair cross-workbook data.Lightweight application that handles large datasets and extensive formula copying without lagging.Free to use with a familiar interface, requiring zero learning curve for seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep asking me to update values when I haven't changed anything?

This happens if your workbook contains hidden or direct formulas that reference another file, and that source file has been moved, renamed, or deleted. Excel automatically attempts to refresh the data upon opening or recalculating but prompts you because it cannot locate the target file.

How can I find which cells contain broken external links in my worksheet?

Press Ctrl + F to open the Find dialog. Enter '.xl' or an open bracket '[' into the search field, change the 'Look in' dropdown to 'Formulas', and click 'Find All'. This will highlight all cells containing references to other Excel workbooks.

Can I permanently stop the Update Links prompt from appearing when I open a file?

Yes. Go to the Data tab, click 'Edit Links', and select 'Startup Prompt' in the bottom left corner. Choose the option 'Don't display the alert and don't update automatic links' (or to update automatically) to suppress the dialog completely.

What happens to my formulas if I click 'Break Link'?

When you break a link in the Edit Links dialog, all formulas in your workbook that reference that specific external source are permanently converted into their current static text or number values. They will no longer update if the source file changes.

Excel & Data Problems