ExcelBanter - formula will only recalculate when i hit the save button -

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula will only recalculate when i hit the save button - (https://www.excelbanter.com/excel-worksheet-functions/237260-formula-will-only-recalculate-when-i-hit-save-button.html)

Andey9

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

Jacob Skaria

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

Shane Devenshire[_2_]

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

All times are GMT +1. The time now is 05:59 AM.