View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Why are my formulas and vlookups not updating?

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