#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Filter is slow

With only 3,000 rows in my Excel file, I find that when I now filter a column
by a number value (greater than a specficied number), what was once an
instantaneous filter now takes about 10 seconds to show the filtered records.

Any ideas why such a simple filter on such a small number of records should
now take 10 seconds?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default Filter is slow

Ed K wrote:
With only 3,000 rows in my Excel file, I find that when I now filter a column
by a number value (greater than a specficied number), what was once an
instantaneous filter now takes about 10 seconds to show the filtered records.

Any ideas why such a simple filter on such a small number of records should
now take 10 seconds?


Excel version?
How big is your Excel file?
Are you running other programs at the same time?
Are you by any chance filtering the entire column rather than just the
rows mentioned?

Could be all sorts of reasons. 3,000 records isn't that small and 10
seconds isn't that long. <g

Bill
Reply
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
Filter PivotTable dropdown items to match report filter Catherine D Excel Discussion (Misc queries) 1 August 16th 08 12:12 AM
Slow scroll with auto filter on Elle Tee Excel Discussion (Misc queries) 0 October 25th 07 09:17 PM
filter: how to print filter list options in dropdown box help please Excel Discussion (Misc queries) 2 October 17th 07 01:53 AM
Slow Excel Navigation with Up / Down Arrow and slow scrolling deddog Excel Discussion (Misc queries) 0 August 14th 07 09:56 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 07:53 PM.

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"