View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thanks thanks is offline
external usenet poster
 
Posts: 48
Default Array formulae do not recalculate

I have a large number of array formulae in my sheet. I update the supporting
data and the formulae do not recalculate. The only way i can get a recalc is
to F2 and then ctrl+shift+enter. How can I get all of the formulae to
recalc. Manual recalc does not work.