GUIDO22
Registered User.
- Local time
- Today, 17:47
- Joined
- Nov 2, 2003
- Messages
- 515
I have a list of a months worth of results in a workbook. One workbook / XLS file for each month.
I want an ANNUAL TOTALS workbook that tabulates the totals from each month/workbook. In this top level workbook, I have links to each group of total cells from each workbook/month.
I want to be able to adjust key parameters in the TOTALS workbook and see the affect on the monthly subtotals in this workbook. This does work OK but , (and heres the rub..), only when I have the monthly workbooks open ie. ALL at the same time.
I only wish to have the top level workbook open - is this possible or does EXCEL expect all files to be physically open in order to perform the calculations required as explained above
...?
Thanks in advance for any help.
I want an ANNUAL TOTALS workbook that tabulates the totals from each month/workbook. In this top level workbook, I have links to each group of total cells from each workbook/month.
I want to be able to adjust key parameters in the TOTALS workbook and see the affect on the monthly subtotals in this workbook. This does work OK but , (and heres the rub..), only when I have the monthly workbooks open ie. ALL at the same time.
I only wish to have the top level workbook open - is this possible or does EXCEL expect all files to be physically open in order to perform the calculations required as explained above

Thanks in advance for any help.