Relative Performance of Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3368028%22%20slang%3D%22en-US%22%3ERelative%20Performance%20of%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3368028%22%20slang%3D%22en-US%22%3E%3CP%3EA%20question%20to%20benchmark%20excel%20performance.%3C%2FP%3E%3CP%3EI%20have%20had%20significant%20performance%20issues%20using%20subtotals.%26nbsp%3B%20Taking%20very%20long%20to%20process%20(go%20and%20get%20a%20coffee%20long).%3C%2FP%3E%3CP%3EThe%20worksheet%20has%2058%2C000%20rows.%3C%2FP%3E%3CP%3EFile%20size%207.58MB%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20guide%2C%20how%20long%20should%20subtotaling%20take%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3368028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3368116%22%20slang%3D%22en-US%22%3ERe%3A%20Relative%20Performance%20of%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3368116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388978%22%20target%3D%22_blank%22%3E%40Peter_William%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3EAs%20a%20guide%2C%20how%20long%20should%20subtotaling%20take%3F%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EAbout%200.001%20seconds%20or%20less.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

A question to benchmark excel performance.

I have had significant performance issues using subtotals.  Taking very long to process (go and get a coffee long).

The worksheet has 58,000 rows.

File size 7.58MB

 

As a guide, how long should subtotaling take?

1 Reply

@Peter_William 

As a guide, how long should subtotaling take?


About 0.001 seconds or less.