Formula refresh

[Marcus]

The problem i am having is i have a excel file with sum formulas entered.
When i enter in a value and hit the tab or enter key the formula will not add
that value to the total. The only way to get the data to populate is to hit
the F9 key or click the Save button and the totals appear.

Am i missing something? I would like the user to enter in data then tab to
the next column and populate the entered data automatically.

Any help would greatly appreciated.

TIA

Marcus

 

[David Biddulph]

Tools/ Options/ Calculation
Set it to Automatic, not Manual.

 

[Luke M]

Go to
Tools-Options, Calculation
Select automatic.

 

[Michael]

From the Main Menu Bar select:
Tools-> Options
From the Calculation Tab Click on Automatic, then save your file.

 

[T. Valko]

Make sure calculation is set to automatic. Tools>Options>Calculation
tab>Automatic>OK

 

[Shane Devenshire]

Hi,

If you are using 2007 choose Formulas tab, Calculation group, Calculation
Options, Automatic

 

[Gord Dibben]

Good idea to save the file with calc mode set to automatic

BUT.......a warning.

If a workbook with calc mode set to manual is the first opened workbook in a
session, all subsequent workbooks opened will also be set to manual even if
they were saved in automatic mode.

You must be aware of this feature in all versions of Excel.


Gord Dibben MS Excel MVP