Thread: How do I speed up recalcs when using lots of SUMPRODUCT formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How do I speed up recalcs when using lots of SUMPRODUCT formulas
The definitive source for optimization:

http://www.decisionmodels.com/

Biff

"Peterdout" wrote in message
...
I have a 33Mb spreadsheet in which I use SUMPRODUCT formulas to make
multiple
criteria selections. This has a severe penalty in recalc time, now between
5-10 minutes. Is there a better way of achieving multiple criteria
selections
without increasing recalc speed.


Reply With QuoteReply With Quote