Why are my formulas and vlookups not updating?

[Guest]

Hello,

I have a workbook with multiple functions - vlookups, sums, etc. The
workbook was working fine, now, the cells are not updating when the data
changes.

For example, a sum of three cells does not update when one of the values in
those three cells changes.

Any ideas?

Thanks,

Jila

 

[David Biddulph]

Have you checked that Tools/ Options/ Calculation is set to Automatic?

 

[Guest]

Check to make sure Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar

 

[Guest]

Thanks Elkar - that did the trick.

Check to make sure Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar

 

[Gord Dibben]

I would assume that your calculation mode is set to manual.

Tools>Options>Calculation "Automatic"


Gord Dibben MS Excel MVP