updating multiple linked spreadsheets

[Colin Foster]

Hello Group,
Have a situation where there is a master summary workbook that is "fed" from
a number of summary workbooks each of which is, in turn, fed by individual
workbooks.
The summary & Individual workbooks are held in their own folders. For
example SummaryJob1.xls and Detail1Job1.xls and Detail2.Job1.xls will all be
in a folder "Job1"...the equivalent workbooks for Job2 wil be in the "Job2"
folder.
I need to ensure that the master summary workbook always has the latest
information. The only way (without having all workbooks open) that I can
think that this can be achieved is to write a macro within the master
summary workbook to open up, calculate & save each of the SummaryJob.xls
workbooks which will then update the master summary.
Am I correct in this, or is there a better way?
Regards
Colin Foster

 

[Township of East Hanover]

you can create and updatable remote reference in a cell put
='Driveletter:\directory of workbook\[workbook name.xls]sheet1'!$A$1

now every time you open this workbook it will ask you if you want to update
your linksm if you say yes it will retrieve the information from the other
workbooks.