Why formula doesn't change on column insertion?

  • Thread starter Thread starter Fred Boer
  • Start date Start date
F

Fred Boer

Hello:

I know I will feel stupid when I hear the answer, but...

If I have a formula ( =average(a1:a5) ), and I insert a new column, the
formula, being relative, changes to ( =average(a1:a6) ). This works fine
in a test. BUT I have a working spreadsheet in which inserting a column does
*not* change the relative formula. Why? I can't see anything different in my
working spreadsheet...
 
Back
Top