why is Excel assuming absolute cell reference

K

K. Georgiadis

I posted this before and, since I am completely
mystified, I am posting again:

"I have three worksheets of identical layout (and in the
same workbook), the 3rd sheet being the where I aggregate
the numbers of the previous two. I am mystified by the
fact that the cell in the same position in sheet one is
assumed to be a relative reference (e.g., Sheet1!B24)
whereas cell B24 in the second sheet is automatically
assumed to be an absolute reference (e.g., Sheet2!$B$24.
Any ideas why this happens?"

I don't see a pattern in Excel's assumption that the cell
reference should be absolute, whereas in seemingly
identical instances it assumes that it is relative. In
several instances, I ended up copying an erroneous
formula across columns because I didn't notice that Excel
was automatically assuming an absolute cell reference.
I'm on the alert now but curious why and when it happens
 
H

Harald Staff

Hi

I can't reproduce this with Excel2000 or Excel2003. All relative addresses.
....Just adding to the mystery ;-)
Can you provide more info on exactly which operations you do to get these
results ?

Best wishes Harald
 
G

Guest

In all instances it was either (a) transferring the
contents of a cell in Sheet1 or Sheet2 to the
corresponding cell in Sheet3 OR (b) aggregating the
contents of cells in Sheet1 or Sheet2 in the
corresponding cell in Sheet3. Nothing fancy...
 
V

Vaughan

I have found that Excel assumes relative references in links to sheets in the same workbook (internal links?), but absolute references in links to other workbooks (external links?). Could this possibly explain it?
 
B

Bob Cresto

If the data comes from another workbook Excel makes it absolute and relative
if it comes from the same workbook.
Could this be the case? Does the data in Sheet2 come from another workbook?
 
Top