View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Excel Woes - Formula bug (I guess)

Hi

First thing is to make sure that Calculation is set to Automatic. Go to
Tools/Options/Calculation to make sure.

Andy.

"mikeydread1" wrote in message
ups.com...
Problem: an excel file is being used for quite some time now (about 2
years), and it suddenly stops updating cells with formulas...for
example: =SUM(c1:C10); the cell is not updated when a value is added to
say... c5. Does anyone know what is happening?, I hoping that I can get
my files back on track as soon as possible.