ExcelBanter - Formula

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Formula (https://www.excelbanter.com/setting-up-configuration-excel/92891-formula.html)

Amy

Formula

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

Formula

Is calculation set to manual? ToolsOptions...Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS

"Amy" wrote in message
...
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?

thunderbird30

Formula

Thanks for your help Nick!
"Nick Hodge" wrote:

Is calculation set to manual? ToolsOptions...Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS

"Amy" wrote in message
...
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?

All times are GMT +1. The time now is 01:18 AM.