caroline.vanbommel
New Member
- Joined
- Aug 21, 2006
- Messages
- 27
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
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