View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
frustrated Professor frustrated Professor is offline
external usenet poster
 
Posts: 1
Default Excel in Office 2007

I create a 2-way table that is populated with random numbers. I then attempt
to calculate some basic descriptive statistics (Min, Max, Average, Stdev,
etc.) of the numbers in the table. When I hit F9, the table recalculates but
the descriptive statistics do not. In fact, the descriptive statistics only
recalculate when the cells containing these functions are "Highlighted."
This is not how things used to be. What is going on? How do I fix this
problem?