I have a cashflow model.
There are 65 workbooks each representing a division and accept prime entry cost data. The results of the same 65 "children" workbooks are linked into and consolidated into a "parent" workbook which aggregates and summarises the results of the 65 sites.
In the parent workbook I have set up flex tables to apply to the children workbooks. e.g. I can input a 5% flex requirement (in parent) which will link and globally adjust base costs by 5% in all the children workbook.
My problem is that unless I open or reopen all 65 children workbooks, the updated aggregated results will not feed back up through to the parent.
Is there a way of updating the parent without opening the children? Or is there another way of creating a global setting for the 65 children which will work around having to open 65 files.
Thank you for reading this. All help gratefully received.