Fix Excel Change Source and Repeated Update Value Prompts
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.

- 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.
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.
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.
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.
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.
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.
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.
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.
Update query connections and PivotTable data sources
Use this when workbook links look correct but refreshing imported data or a PivotTable still triggers a source prompt.
Collect a reproducible example for further investigation
Use this if the prompts continue after you have checked formulas, names, queries, and PivotTable sources.
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.

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.




