View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Why are my formulas and vlookups not updating?

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