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

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

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

Check to make sure Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar


"JilaJ" wrote:

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

Thanks Elkar - that did the trick.

"Elkar" wrote:

Check to make sure Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar


"JilaJ" wrote:

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

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

ToolsOptionsCalculation "Automatic"


Gord Dibben MS Excel MVP

On Tue, 20 Mar 2007 15:25:26 -0700, JilaJ
wrote:

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