Top Level Workbook / References..

[GUIDO22]

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.

 

[kajobkajob2]

If I had your problem, I would use different worksheets for every individual month, not workbooks.
This simply means that they would all open at the same time. IN THE SAME workbook.
To do this, unless you have external data connections, where you have imported data from other software e.g MS access, just copy and paste what's on each workbook on to a new worksheet in your "top level" work book. Just to make things clearer you could also rename the worksheets.

However, VBA might help with our problem. I've just given a way to work round the solution.

 

[GUIDO22]

Thank you for your response. Your suggestion is an option, but to my mind is far from ideal.
Because of the wealth of data that I am analysing (upto 250 rows of data per day), I wish to be able to reference the daily totals on the summary sheet with ease. With each MONTHLY worksheet having thousands of rows of data pinpioting the cell containing the days totals on the top level SUMMARY sheet is not going to be easy and will change day to day.

Presently each worksheet contains a DAYS worth of data only and the total for the day efforts, on each worksheet is always the same physical cell. So the reference on the SUMMARY sheet is the same physical CELL reference, this makes updating the summary sheet simple.