Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter Slow problem
The auto filter behaves differently on differnet sheets.
I have auto filter on two sheets. Sheet1 has around 30000 rows with no ole objects, and If I do auto filter then it takes around 2 seconds. Sheet2 has around 700 rows but it has four charts as well as ole vb controls such as combo box, option btns and check box and command btn. The auto filter on this sheet takes around 8 seconds. Is Autofilter performance on sheet2 is slow because of ole objects? Is there way I can fix time problem on autofilter on sheet2? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slow copying problem | Excel Worksheet Functions | |||
Need help with slow AutoFilter | Excel Programming | |||
Can somebody help me with a slow macro problem. | Excel Programming | |||
Very Slow Macro Problem | Excel Programming | |||
AutoFilter Best Practice when used in large files (slow system dow | Excel Discussion (Misc queries) |