J
Jim
The autofilter locks up on me when trying to change the
filtered values. How can I fix this?
filtered values. How can I fix this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John
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.
Good Luck
John
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.
Good Luck
John
O
Otto Moehrbach
John
Tell me more about this Resource Meter tool. I've never heard of it and
it sounds like something good to know about. Thanks. Otto
Tell me more about this Resource Meter tool. I've never heard of it and
it sounds like something good to know about. Thanks. Otto
D
Dave Peterson
I use win98.
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.)
Have your Windows CD available.
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.)
Have your Windows CD available.
G
GRAPL
Hi
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.
Regards
GRAPL
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.
Regards
GRAPL