sumproduct, arrays affecting speed
 

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.

sumproduct, arrays affecting speed
 

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.

sumproduct, arrays affecting speed
 

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.

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.

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.