Formula Errors

Fix Excel Change Source and Repeated Update Value Prompts

Ayan MasoodAyan Masood Nov 13, 2026 869 views

Question details

The user needs to stop repeated Update Value dialogs after changing external link sources in an Excel workbook containing flat-file data and a PivotTable.

Fix Excel Change Source and Repeated Update Value Prompts
Product
Microsoft Excel
Device & OS
not provided
Scenario
Changing the source of external links used by worksheet formulas and a PivotTable.
Observed behavior
Excel repeatedly requests a source through the Update Value dialog after the source has been changed.
Before you start

Open the replacement source file to confirm its exact path, filename, worksheet names, and accessibility. Test changes in a copy of the affected workbook, and capture the Change Source and Update Value dialogs before dismissing them.

Solution 1Recommended

Correct external workbook links and named references

Use this first when Excel keeps asking for a workbook after you have changed its link source.

Repeated prompts can indicate unresolved references to an old workbook, a missing worksheet or named range, or a source location that Excel cannot access. Changing one workbook link does not necessarily update separate query or PivotTable connections.

1
Identify the requested source

When Update Value appears, record the workbook or source name shown in the dialog. Open the intended replacement file using File > Open and verify that it is accessible.

2
Change the workbook link

In the affected workbook, open Data > Workbook Links, or Data > Edit Links in versions that use the older dialog. Select the outdated source, choose Change Source, and select the correct replacement workbook.

3
Search for remaining formula references

Open Home > Find & Select > Find. Expand Options, set Within to Workbook and Look in to Formulas, then search for the old filename or path. Use Find All to locate references and correct affected formulas, checking that the referenced worksheets and ranges exist.

4
Inspect named ranges

Open Formulas > Name Manager. Review the Refers to field for workbook-level and worksheet-level names, especially entries containing the old filename, an external path, or #REF!. Select an affected name and choose Edit to correct its reference.

5
Test the revised links

Save the test copy, close it, and reopen it. If an Update Value dialog returns, record the source it now requests and check whether that source differs from the one you already changed.

Avoid breaking links as a first step: Break Links replaces linked formulas with their current values and removes their ability to update from the source. Use it only if you intentionally want static data.
Free Microsoft Office alternative

Use WPS Spreadsheet for Everyday Excel Workbook Editing

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Excel format compatibility for easy migration. It can support everyday workbook editing, but it does not repair Excel's Change Source dialogs; advanced external connections and PivotTable behavior should be tested before switching.

Open and edit Microsoft Excel .xlsx and .xls files.Work with worksheet data and formulas in a familiar spreadsheet interface.Use a lightweight Office suite for everyday spreadsheet tasks.Review ordinary workbook content while validating external-link and PivotTable compatibility separately.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep showing Update Value after I change the source?

The workbook may still contain references to an old source in formulas, named ranges, queries, or PivotTable connections. The replacement workbook may also lack a referenced worksheet or named range. Check Data > Workbook Links or Edit Links, then inspect Formulas > Name Manager and Data > Queries & Connections.

Does Change Source update a PivotTable's data connection too?

Do not assume it does. Changing a formula's workbook link does not necessarily change a separate query or external connection. Click the PivotTable and check PivotTable Analyze > Change Data Source, or inspect the underlying query or connection for connection-based PivotTables.

How can I find formulas that still reference the old workbook?

Open Home > Find & Select > Find, expand Options, set Within to Workbook and Look in to Formulas, and search for the old workbook name or path. Also check Formulas > Name Manager because a formula search alone does not cover all named references.

Should I use Break Links to stop the prompts?

Only if you no longer need the linked formulas to update. Data > Workbook Links or Edit Links provides a Break Links option, but it converts linked formulas to their current values. It also does not necessarily remove separate query or PivotTable connections.

What should I provide if the problem still cannot be identified?

Provide screenshots of both dialogs, the Excel version, the actions that reproduce the prompt, and a sanitized sample workbook. Include sanitized source files if needed, and verify that the sample still shows the problem before sharing it.