Table reference

[RobbeV1]

I've been using [@[column name]] as a relative cell reference in my excel sheet.
Previously I could fill down the formulas and the results would be based on the values in the same row as the cell wherein the formula was placed. (first scenario)

No columns where added in the meanwhile and the formula was not changed.
Now the same formula behaves as an absolute cell reference, since it takes the values of the row of the orginal cell that is filled down.
(Second scenario)

Is their an setting that I might have changed in order for the relative reference to behave in an absolute manner?

To give an example:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]column1[/TD]
[TD]column2[/TD]
[TD]Formula[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Last cell is to be filled down[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][@[column1]]+[@[column2]][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]First scenario[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][@[column1]]+[@[column2]][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Second scenario[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][@[column1]]+[@[column2]][/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


If more details are needed, be sure to ask.

Thank you in advance.

 

[pbornemeier]

In Excel 2010, in a table, this works for me: =[@Column1]+[@Column2]

If I enter this: =[@[column1]]+[@[column2]] it gets changed to the formula above and works as a relative reference.

I don't know of a setting that could cause your problem.

Is your recalculation set to automatic?