View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vj Vj is offline
external usenet poster
 
Posts: 54
Default 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.