software

I just created a new worksheet, when I create formulas it calculates them,
for example a SUM formula. Bit if I change the data in the cells, it does not
auto recalculate, I have to go to each individual cell and hit the function
key to get it to recalculate! ANNOYING

How do I turn on auto-recaclulate for formulas?

toolsgt;optionsgt;calculation and set to automatic

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Markquot; gt; wrote in message
...
gt;I just created a new worksheet, when I create formulas it calculates them,
gt; for example a SUM formula. Bit if I change the data in the cells, it does
gt; not
gt; auto recalculate, I have to go to each individual cell and hit the
gt; function
gt; key to get it to recalculate! ANNOYING
gt;
gt; How do I turn on auto-recaclulate for formulas?