I have a very odd occurrence happening. My linked data is not updating when my source file is open. I have a central workbook that has links to about two-dozen source workbooks. The links work properly when I open the 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.
If I then save the source file and click Edit Links >> Update Values in the Connections section of the Data tab of the Master workbook, the data updates. I don't want to have to perform this manual "push" every time I update the source.
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. It retains the entire file path (i.e. 'C:\shared\username\folder\[filename.xlsm]sourcedata'!$D$3) instead of simply beginning with the bracketed expression ([filename.xlsm]sourcedata!$D$3).
Using Excel 2013.
I have checked my calculation settings to automatic, and have Trust-Center set to the most permissive setting possible. I have automatic updating of links turned on. This workbook is password protected for EDITING (it can be viewed without a password).
Please help!!
If I then save the source file and click Edit Links >> Update Values in the Connections section of the Data tab of the Master workbook, the data updates. I don't want to have to perform this manual "push" every time I update the source.
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. It retains the entire file path (i.e. 'C:\shared\username\folder\[filename.xlsm]sourcedata'!$D$3) instead of simply beginning with the bracketed expression ([filename.xlsm]sourcedata!$D$3).
Using Excel 2013.
I have checked my calculation settings to automatic, and have Trust-Center set to the most permissive setting possible. I have automatic updating of links turned on. This workbook is password protected for EDITING (it can be viewed without a password).
Please help!!
Last edited:
