Calculating across workbooks

[Guest]

I am using Excel 2003, with five different workbooks open. One of these is a
summary of the other four. When I click in a cell of the summary workbook,
and type = I then choose one of the workbooks choose a cell and press enter.
Back in the summary sheet the sheet name of the other workbook appears, in
square brackets, followed by the sheet number and an exclamation mark, and
the cell reference of the source workbook. Why does this cell reference
appear as an absolute reference?

 

[Dave Peterson]

I don't have any idea why. I guess it's a question for MS.

But if the worksheet is in the current workbook, the addresses are relative.

Maybe you can move the worksheet into the workbook, do your pointing and
clicking and move the worksheet back to its rightful home???