R
ruthhicks999
I am having a real issue with autofilter in Excel 2003. I have had it
since I first installed the upgraded office version after a machine
rebuild. This particular spreadsheet was created on 2000 if that makes
a difference and it has other sheets which have autofilters on them,
although I have had it on others too.
I can set the autofilter all OK and then I can use it to filter on
maybe one or two occasions with the added extra of the blue triangle to
tell me which columns have a filter applied BUT THEN.....
I get to a stage where no matter what I do I get no options when trying
to change the filter options. This most often happens when I have
filtered to show only one person, to show only the pupil whose
coursework I am in the middle of marking. Turning the autofilter off
and back on makes the problem worse as I then loose the blue drop down
triangle. I have to unhide the rows to get back to the start.
Marking 200 pieces of coursework over the Easter 'Holiday' is bad
enough but with Excel not playing ball it is making it just that little
bit worse. I hope someone can help.
since I first installed the upgraded office version after a machine
rebuild. This particular spreadsheet was created on 2000 if that makes
a difference and it has other sheets which have autofilters on them,
although I have had it on others too.
I can set the autofilter all OK and then I can use it to filter on
maybe one or two occasions with the added extra of the blue triangle to
tell me which columns have a filter applied BUT THEN.....
I get to a stage where no matter what I do I get no options when trying
to change the filter options. This most often happens when I have
filtered to show only one person, to show only the pupil whose
coursework I am in the middle of marking. Turning the autofilter off
and back on makes the problem worse as I then loose the blue drop down
triangle. I have to unhide the rows to get back to the start.
Marking 200 pieces of coursework over the Easter 'Holiday' is bad
enough but with Excel not playing ball it is making it just that little
bit worse. I hope someone can help.