MrRhodes2004
01-10-2007, 11:50 AM
Hey Group,
I have a question with nested linked files. Let us say there are five files (A, B, C, D, E) that are linked in serial and internally cross-linked.
File A is the summary file that collects and processes the information contained in the other four files.
File B through File E are inter-related and interlinked. Their information is inter-dependant upon the other files.
To simplify the question, A is linked to B, B to C, C to D, and D to E.
When file A is opened, the values are automatically updated from B. If changes were made in file E, file A may not know or reflect those changes.
To make the question more difficult than it needs, if the information in file E causes a change in file B which then causes a change in file D . . . and so on. I control file A and others control (I do have master control though) files B through E.
Is there a way to ensure that when file A is opened and ?updates values? it is truly updating all the values from all the nested linked files?
They way I have been doing it manually is to open file A > edit links > select and open all source files. Then once all those files are opened, I do the same, opening all of the source files. This means having many files open at the same time. For the current project that I am working on, I had 15 files open at one time to make sure that the data is the summary was updated correctly.
Does Excel already make these changes? In my experience, it does not seem too. Is there a simplified code that allows this to happen automatically?
Thanks,
Michael
I have a question with nested linked files. Let us say there are five files (A, B, C, D, E) that are linked in serial and internally cross-linked.
File A is the summary file that collects and processes the information contained in the other four files.
File B through File E are inter-related and interlinked. Their information is inter-dependant upon the other files.
To simplify the question, A is linked to B, B to C, C to D, and D to E.
When file A is opened, the values are automatically updated from B. If changes were made in file E, file A may not know or reflect those changes.
To make the question more difficult than it needs, if the information in file E causes a change in file B which then causes a change in file D . . . and so on. I control file A and others control (I do have master control though) files B through E.
Is there a way to ensure that when file A is opened and ?updates values? it is truly updating all the values from all the nested linked files?
They way I have been doing it manually is to open file A > edit links > select and open all source files. Then once all those files are opened, I do the same, opening all of the source files. This means having many files open at the same time. For the current project that I am working on, I had 15 files open at one time to make sure that the data is the summary was updated correctly.
Does Excel already make these changes? In my experience, it does not seem too. Is there a simplified code that allows this to happen automatically?
Thanks,
Michael