How to Find Excel Workbook Links Still Pointing to Last Month
The forecast tab says November. One line still pulls from October’s workbook. The figure looks plausible because the two files differ by only $4,600. Find the connection before asking who changed the forecast.
Open Data → Workbook Links and inspect the referenced source. Check formulas, names, charts and any workbook queries that feed the line. Then compare the old and intended source values before changing links.
Three lines in the copied forecast
This sample checks the reported values against the approved November source workbook.
| Forecast line | In November report | Approved November source | Evidence |
|---|---|---|---|
| Freight | $31,800 | $36,400 | Formula refers to October.xlsx |
| Storage | $12,000 | $12,000 | Formula refers to November.xlsx |
| Handling | $18,200 | $18,200 | Formula refers to November.xlsx |
The evidence points to Freight. The difference is $4,600. Trace that formula and any shared name before changing the workbook source for the entire report.
Recreate the stale link in three small files
This is a synthetic Excel desktop exercise. Create October.xlsx and November.xlsx in the same practice folder. In each file, name a worksheet Inputs and put Line in A1 and Amount in B1. Use Freight, Storage and Handling in A2:A4, in that order. Enter 31800, 12000 and 18200 in October’s B2:B4; enter 36400, 12000 and 18200 in November’s B2:B4. Save both files.
Create Forecast.xlsx with a Report sheet. Put the same three labels in A2:A4. With all three workbooks open, build these links by typing = in each Report cell and selecting the specified source cell. Excel will insert the external reference. The formulas should identify these sources:
Report!B2: =[October.xlsx]Inputs!$B$2 Report!B3: =[November.xlsx]Inputs!$B$3 Report!B4: =[November.xlsx]Inputs!$B$4 Report!B5: =SUM(B2:B4)
The expected total in Report!B5 is $62,000. Freight in Report!B2 reads October Inputs!B2, $31,800, while the approved November Inputs!B2 contains $36,400. Rebuild only Report!B2 by selecting November’s Inputs!B2. The expected total becomes $66,600. Storage and Handling stay $12,000 and $18,200.
These references describe the open-workbook setup. Excel may show a folder path when a source is closed. Record the actual source path, sheet and cell in your own check. A successful refresh of October.xlsx can still leave the November report wrong: it refreshes the source already selected.
In a real report, keep legitimate prior-month comparison links. Changing a source for the whole workbook can affect more than the one line you meant to fix. Confirm which references should move before using Change source.
Locate what’s still linked
Use Workbook Links to inspect sources. Search formulas for the old workbook name or .xl reference and open Name Manager for any defined names that refer to the old file. Check chart series and queries where the report uses them. A query’s Source step can be a separate dependency.
For a formula search in Excel desktop, open Find, expand Options, set Within to Workbook and Look in to Formulas, then search for October.xlsx or .xl and use Find All. Treat an empty search as one check, not proof that every dependency is current. Workbook-link inspection and query-source inspection are separate checks.
The sums and $4,600 difference were independently checked. This exercise was not run in native Excel, external links were not refreshed in a live workbook, and a live Jolene.pro result could not be verified. The cell references above belong to the setup you create, rather than an uploaded customer workbook.
For a separate reporting-period problem, see the month-end SUMIFS timestamp check. Browse more synthetic exercises in Jolene.pro Workbook Studies.
Check the result after changing a source
Work on a copy and confirm the intended workbook has the necessary sheets, definitions and dates. Update the appropriate link or formula, recalculate and compare affected lines with the approved input. Breaking a link converts linked formulas to values, so review that action separately.
Compare the output with both source workbooks
Bring the approved input snapshot and actual reported totals into one workbook for the row-level check. Keep formula evidence alongside it when available.
Which November report lines differ from the approved November input and match October instead? Show the three values, numerical differences and source cells.
Fix the confirmed link in Excel and repeat the comparison. Matching October’s value is a clue to check, since an unchanged number can match both months.
Microsoft’s Workbook Links guide · Microsoft on refreshing Excel connections
The figures and identifiers in this example are synthetic.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.