Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Slow scroll with auto filter on | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |