How do I calculate cells across Excel 2003 workbooks?

[mj]

I have three different workbook files stored in the same folder and I want to
have the three worksheets in each of the three workbooks totaled in a new
workbook file. I am trying to create a quarterly report from three months of
data. All data is located in the same cells in the worksheets in each of the
workbooks.

[Barb Reinhardt]

If the different workbook files were all in the same workbook, it would be a
lot easier. Can that be done?

"mj" <[email protected]> wrote in message
news:[email protected]...
>I have three different workbook files stored in the same folder and I want
>to
> have the three worksheets in each of the three workbooks totaled in a new
> workbook file. I am trying to create a quarterly report from three months
> of
> data. All data is located in the same cells in the worksheets in each of
> the
> workbooks.

[flummi]

If you have all workbooks open you can use them in any cell references
by selecting the appropriate window and worksheet and cell. Excel will
take care of the file paths if you close the workbooks (the summary
workbook last)

Hans