View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Formula not updating

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK


--
Biff
Microsoft Excel MVP


"Katie" wrote in message
...
I am using very basic formula to calculate sums on a spreadsheet, and
usually
it works fine, but for some reason they are no longer updating? Does
anyone
know why? The formula still seems to be in the cell, but it doesn't change
when I amend the numbers above it.
Using Excel 2003.