Dont want to open all linked workbooks

[caroline.vanbommel]

mine is a bit simpler i think.
I have one main workbook that is linked to 2 other workbooks(and those 2 others are both linked each to 2 other workbooks
So when i open my analysis (main workbook, used just as a viewer sheet ) , i have to open the other 6 workbooks.
I want to avoid having to do this.

4x Masterdata wookbooks ( refreshed monthly)
2x Analysis and Formulas ( variables that are manually changed eg month)
1x Consolidated workbook of the analysis one.

so is there a way to not have to open all of these workbooks if i just want to view the consolidated workbook

 

[Andrew Poulsom]

I replied here:

http://www.mrexcel.com/board2/viewtopic.php?t=235585