sumproduct, arrays affecting speed

[Guest]

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.

 

[Biff]

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

 

[Bob Phillips]

Yeah, but extra rows aren't exactly going to speed things up :-(

Bob

 

[Biff]

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

Biff

 

[Bob Phillips]

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