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