Check to see if "Automatic Calculations" is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar


"timbrook" wrote:

I have a column of numbers thar I have averaged. If I change one of the
numbers I have to insert the average function again. Why?