View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default sumproduct, arrays affecting speed

Yeah, but now we can write formulas that use ROW(1:1048576) :-)

Biff

"Bob Phillips" wrote in message
...
Yeah, but extra rows aren't exactly going to speed things up :-(

Bob

"Biff" wrote in message
...
Hi!

To see what MS is up to:

http://blogs.msdn.com/excel/default.aspx

Tips and general info for optimization:

http://www.decisionmodels.com/

Biff

"Dave Breitenbach" wrote in
message ...
Does anyone know if microsoft is addressing the major slowdown seen in
calculation speed when using advanced functions like sumproduct and

array
functions?

I'm enjoying the possibilities they create but am getting quickly

limited
in
speed.