sumproduct, arrays affecting speed

[Dave Breitenbach]

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

"Dave Breitenbach" <[email protected]> wrote in
message news:[email protected]...
> 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.
>
>

[Bob Phillips]

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

Bob

"Biff" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
> > 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]

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

Biff

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Yeah, but extra rows aren't exactly going to speed things up :-(
>
> Bob
>
> "Biff" <[email protected]> wrote in message
> news:%[email protected]...
>> 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" <[email protected]> wrote in
>> message news:[email protected]...
>> > 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.
>> >
>> >
>>
>>
>
>

[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


"Biff" <[email protected]> wrote in message
news:%[email protected]...
> Yeah, but now we can write formulas that use ROW(1:1048576) :-)
>
> Biff
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > Yeah, but extra rows aren't exactly going to speed things up :-(
> >
> > Bob
> >
> > "Biff" <[email protected]> wrote in message
> > news:%[email protected]...
> >> 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" <[email protected]> wrote in
> >> message news:[email protected]...
> >> > 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.
> >> >
> >> >
> >>
> >>
> >
> >
>
>