Hi, just a quick question really, I have a feeling it can probably be resolved quite quickly but I just don't know how.
Basically, I have a formula containing absolute cell references, but whenever I insert a new row into the table that the reference is looking at, the cells bound by the absolute reference change.
I thought the point of using absolute cell references is that they don't change?
Anyway, is there some way around this, to avoid the cell reference changing when a row is inserted?
Thanks in advance for any help.
Bookmarks