LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
slow copying problem yogart Excel Worksheet Functions 6 December 24th 08 04:23 PM
Need help with slow AutoFilter [email protected] Excel Programming 1 July 6th 07 08:58 PM
Can somebody help me with a slow macro problem. JeffMelton Excel Programming 2 October 13th 06 02:45 AM
Very Slow Macro Problem Dean[_9_] Excel Programming 3 March 24th 06 04:15 PM
AutoFilter Best Practice when used in large files (slow system dow Dennis Excel Discussion (Misc queries) 2 February 17th 06 07:53 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"