Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter Best Practice when used in large files (slow system dow
Using 2003
In large files (20,000+ records on various sheets) is there an efficient way or procedure to speed up the use of selecting choices with the AutoFilter dropdown box(es)? I have: reset the last cell (on each sheet) re-booted released the filter before choicing the next option and a few other stabs in the dark. If anyone has some ideas that have worked plese let me know. I wish that XL had a utility to "scrub" the .xls files for efficiency like Access has. Thanks Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 slow when working with excel 2000 files | Excel Discussion (Misc queries) | |||
Simple worksheet becomes large and slow | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
Using large excel files | Excel Worksheet Functions | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) |