| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
| How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Hybrid Mode
