Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faster AutoFilter?
Second question today.....
Is there a way of using the Application.ScreenUpdating = False method on AutoFilter? I've currently got a ten column data range of about 6000 rows and the AutoFilters takes a long time to work. All alternative solutions welcome! Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faster AutoFilter?
Hi
try disabling automatic calculation before applying the filter -- Regards Frank Kabel Frankfurt, Germany John wrote: Second question today..... Is there a way of using the Application.ScreenUpdating = False method on AutoFilter? I've currently got a ten column data range of about 6000 rows and the AutoFilters takes a long time to work. All alternative solutions welcome! Thanks John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faster AutoFilter?
Hi Frank,
I've tried your sugestion, but I think that as it's mostly text it doesn't appear to make a big difference. Thanks John "Frank Kabel" wrote in message ... Hi try disabling automatic calculation before applying the filter -- Regards Frank Kabel Frankfurt, Germany John wrote: Second question today..... Is there a way of using the Application.ScreenUpdating = False method on AutoFilter? I've currently got a ten column data range of about 6000 rows and the AutoFilters takes a long time to work. All alternative solutions welcome! Thanks John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Faster AutoFilter?
If it's mostly text, maybe you can apply the filter and then hit a key to
interrupt calculation (I hit the Escape key by habit). The filtered data shows up nicely, but I get a "calculate" in the statusbar. (When I'm gazing at the results, excel can calculate what it thinks it needs to calculate.) I do the same thing when I do Data|filter|showall. I interrupt the calculation. I've found that excel calculates lots faster when there's nothing filtered. John wrote: Hi Frank, I've tried your sugestion, but I think that as it's mostly text it doesn't appear to make a big difference. Thanks John "Frank Kabel" wrote in message ... Hi try disabling automatic calculation before applying the filter -- Regards Frank Kabel Frankfurt, Germany John wrote: Second question today..... Is there a way of using the Application.ScreenUpdating = False method on AutoFilter? I've currently got a ten column data range of about 6000 rows and the AutoFilters takes a long time to work. All alternative solutions welcome! Thanks John -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) |