To update the links automatically as you open any workbook: 1) Open Microsoft Excel workbook.2) Click the 'Microsoft Office' button on the top left. (The 'Excel Options' dialog box appears.) 4) From the left pane, click 'Advanced'.There are many options in Excel that control this depending on the kind of link it is.I’ll cover the usual external links in formulas first, then finish up with the other kinds.The cell references were all correct, but for whatever reason they would not update.
If you get a prompt to update links when you open a workbook, but you cannot find any cells containing links, the link is probably in a name. If the source workbooks are open at the same time as the target, the formulas are part of the recalculation chain as normal.The only symptom I can find is that the reference to the source file in the Master file does not become an internal reference when the source workbook is open. 'C:\shared\username\folder[filename.xlsm]sourcedata'! $D) instead of simply beginning with the bracketed expression ([filename.xlsm]sourcedata! I think your links are trying to open the file, even though you already have the file open.If they aren't shared, it won't be able to open them. Linked data in a Master workbook is not updating when one of its source files are open.I have a Master workbook that has links to about two-dozen source workbooks.So I closed out of my work so my boss could review.