| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Auto Shorten a Data String | Excel Discussion (Misc queries) | |||
| I want to create a macro to where after we enter data in a spread. | Excel Worksheet Functions | |||
Linear Mode
