Formula Errors

How to Stop Excel Update Values Dialog from Appearing Repeatedly

Adam Davis Oct 14, 2026 871 views

Question details

The user is repeatedly prompted with an Update Values dialog box when pasting data between workbooks.

How to Stop the Update Values Dialog from Appearing Repeatedly in Excel

Product: Excel
Device & OS: not provided
Scenario: Pasting values from one workbook to another that contains formulas like INDEX and MATCH, which inadvertently carries over external references.
Observed behavior: An Update Values dialog repeatedly appears, asking the user to resolve external links to the source workbook.

Before you start

Ensure both your source and destination workbooks are saved before proceeding, as you will be modifying how formulas and external links are handled in the destination file.

Solution 1Recommended

Use Paste Special to Paste Values Only

This method ensures that only the raw data is pasted into the destination workbook, preventing the accidental transfer of formulas that create broken external links.

When you use the standard paste command, Excel copies the formulas and their original references. If these formulas reference another workbook, Excel creates an external link. Using Paste Special allows you to paste only the static values, bypassing the issue entirely.

Copy the Data

Select the required data in the source workbook and press Ctrl+C to copy it.

Access Paste Special

Switch to the destination workbook, right-click the target cell where you want the data to start, and select "Paste Special" from the context menu.

Select Values

In the Paste Special dialog box, select the "Values" radio button and click "OK". The data will be pasted without carrying over any external formulas.

Pro Tip: You can also use the keyboard shortcut Ctrl+Shift+V in many modern spreadsheet applications to paste values directly.

Solution 2

Review and Break Unwanted External Links

If the destination workbook already contains external links causing the Update Values prompt, breaking these links will convert the problematic formulas into static values.

Solution 3

Convert Pasted Content Using Text to Columns

If pasted data behaves unexpectedly or retains hidden formatting that triggers link errors, converting it to pure text can resolve the issue.

WPS Spreadsheet Solution

Manage External Links and Paste Values Seamlessly in WPS Office

WPS Spreadsheet provides a highly compatible and intuitive interface for managing external workbook references, breaking unwanted links, and pasting values without triggering annoying dialog boxes.

1. Open Your Workbooks: Launch WPS Spreadsheet and open both your source and destination workbooks.
2. Copy the Data: Select the cells in the source workbook that you want to transfer and press Ctrl+C.
3. Select Paste Special: Navigate to the destination workbook, right-click the target cell, and choose "Paste Special".
4. Paste Values Only: Select the "Values" option in the dialog box and click OK to paste without triggering any external link update prompts.

Easily paste values without bringing over unwanted external links.Highly compatible with all Microsoft Excel file formats (.xlsx, .xls, .csv).Lightweight application that runs smoothly even with multiple large workbooks open.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Update Values dialog keep popping up?

This happens when your workbook contains formulas (like VLOOKUP, INDEX, or MATCH) that reference another workbook. If the spreadsheet software cannot automatically locate the source file or resolve the reference, it prompts you to manually update the values.

How can I quickly find which cells contain external links?

You can use the Find feature by pressing Ctrl+F. Search for the open bracket symbol "[", as it is universally used in spreadsheet formulas to indicate a reference to an external workbook file.

Can I completely turn off the Update Values startup prompt?

Yes. Go to the Data tab and click Edit Links. Click on "Startup Prompt" at the bottom of the dialog box, and select "Don't display the alert and don't update automatic links" to suppress the popup when opening the file.

Excel & Data Problems