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?
--
technology made easy