how do I turn ON auto REcalculate for formulas if new data enter?
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? |
how do I turn ON auto REcalculate for formulas if new data enter?
toolsoptionscalculation and set to automatic
-- Regards, Peo Sjoblom Portland, Oregon "Mark" wrote in message ... 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? |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com