View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default Formulas are not working/updating

Check Tools-Options on the calculation tab make sure it is set to Automatic.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"TexasIndoorGolf" wrote:

I noticed about a week ago that none of my formulas in any of my worksheets
are updating - meaning that if I change a number in a column that is being
summed, the sum will not change. This applies to ALL of the formulas I
create in Excel. Did I change a setting in Excel that I don't know about?