Autofilter uses lots of memory - like Excel does in
general - generally this happens when you run out of
memory. You may want to active the Resource Meter system
tool before opening your workbook. If it goes red when
you activate the filter you don't have enough memory. Try
to reduce the size of the workbook - remove colors, macros
etc. and then retry the filtering.
Windows Start button|Programs|Accessories|System tools|Resource Meter
(but I'm not sure it was there when I installed or put it there after.)
The shortcut points at this: C:\WINDOWS\RSRCMTR.EXE
I went to Windows Start button|Settings|Control Panel|Add remove programs|
Windows Setup and this was buried under system tools|Details
(there's a system monitor and a system resoure monitor there, too.)
I experience the same problem as the original post, but
have noticed that it only occurs if I do intermediate
saves while editing my spreadsheet. Once I have saved, I
need to select the whole worksheet, turn off auto-filter,
Unhide all rows and columns even if none have been hidden.
I have to do this at least twice before turning Auto-filer
on again before I can use the drop down lists to re-filter
my data.
There doesn't appear to be anything in the abiut this in
the Knowledge Base.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
