Hermafrodit date site - Spreadsheet links not updating
The links work properly when I open the Master file.
However, if I open both the Master workbook and one of the source files and proceed to change one of the inputs from the source file, the update does not flow through to the Master file.
Use the Name Manager (either Excel’s own or the free third-party JKP Name Manager ) to check all names for links, particularly phantom links which are not used but clutter up the list. The link values from closed files are not refreshed in a recalculation.
To control whether values are updated when the workbook containing the links (the ‘target’ workbook) is opened, use the Edit Links button in the Data tab of the Ribbon. If true, the user is alerted and can choose whether to update or not. 2: Don’t display the alert and don’t update automatic links Links are not updated at startup, regardless of the setting of Application. 3: Don’t display the alert and update links Links are updated at startup, regardless of the setting of Application. Excel provides no way to automatically refresh the values of external link formulas to CLOSED workbooks. To update all links, pass it the array of link sources as follows: If you omit the parameter, by default Excel uses xl Link Type Excel Links.
Not sure if its just my computer yet, currently testing the issue with different computers.