| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula will only recalculate when i hit the save button -
The formula will only update when i hit the same button - have checked
"options" within "Tools" but everything seems ok - any ideas? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula will only recalculate when i hit the save button -
If the formulas are not UDF's then set the calculation to Automatic from
ToolsOptionsCalculation tab -- If this post helps click Yes --------------- Jacob Skaria "Andey9" wrote: The formula will only update when i hit the same button - have checked "options" within "Tools" but everything seems ok - any ideas? thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula will only recalculate when i hit the save button -
Hi,
In 2007 choose Formulas, Calculation Options, Automatic -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Andey9" wrote: The formula will only update when i hit the same button - have checked "options" within "Tools" but everything seems ok - any ideas? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The SAVE AS button does not show save to G: drive | New Users to Excel | |||
| Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
| Recalculate Formula when field value changes | Excel Discussion (Misc queries) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| save as isnt there neither is the save button pressable | Excel Discussion (Misc queries) | |||
Linear Mode
