Formula

[Guest]

I am working with many excel spreadsheets that when you enter a new number in
a cell it will not update the formula cell until you save the worksheet?
Any Clue?

 

[Nick Hodge]

Is calculation set to manual? Tools>Options...>Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

Thanks for your help Nick!

Is calculation set to manual? Tools>Options...>Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)