The formula will adjust itself only if the new row is inserted before the
last row and after the first row used in the formula.

changing the function to =SUM(F2:F100) should fix the problem. Try it.

"bcg" wrote in message
...
We have an Excel 2002 spreadsheet where we are using the AutoSum Function
to
total an entire column. Currently, the function "=SUM(F2:F99)" is in Cell
F101 and Row 100 is empty. When we inserting a new row into the empty row
of
this spreadsheet, the function does not automatically update. "Options:
Calculation" is set to Automatic.

If we change the function to "=SUM(F2:F100)", will that fix the problem?
If
not, any other suggestions?

Thanks in advance for the help