Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating across workbooks
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating across workbooks
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??? Jeremy Borino wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |