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

True, but how fast (slow?) will that be? The one good thing is we can test
for dates upto 25 Nov 4770. Somehow, I don't expect human life to be around
then.

Bob


"Biff" wrote in message
...
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.