update automatically the links

[jevi]

Hi All:

I am having problems with the updating of links and got at the final results:

1. I have the data saved in a folder (Data) and then in another folder (Target) I have linked the workbook of target with the data workbook. and then I have another folder within the folder of target (Summary) and the workbook of Summary is linked to the Target data.

2. I can see then when i do changes in the folder Data and go to Target workbook, i check Enable all Content and the data is updated. But when i open work book Summary and check Enable all content the data is not updated.

3. But if i save the workbook Summary at the same folder of Target, the workbook summary data is updated automatically!

How can they update automatically? Even if they are closed or opened or in different folders...my thought was that if u change data in a source other links are update automatically, opened or not.

Thank you....!

 

[GlennUK]

It has nothing to do with location. You must have been opening and updating things in the wrong order ... if you update Data, and then update links in Target and save that, then you will be able to see your latest data in Summary. Excel will NOT update links in closed workbooks if you change the data that they refer to .... it updates the links when you open the workbooks. So, open your workbooks ( and save them ) in the correct order to propogate data values through different levels of linking.