Filters  
Author Message
TimKatanik





PostPosted: Fri Oct 28 20:46:22 CDT 2005 Top

Excel Programming >> Filters

Hello,
Sometimes when I put a filter on a row, the filters appear but do not work.
You can select them and they won't show anything. Delete them and put them
back on manually, they work. Any ideas?

Bill

Excel242  
 
 
David





PostPosted: Fri Oct 28 20:46:22 CDT 2005 Top

Excel Programming >> Filters Hi Bill,
Never heard of it. Did you copy and paste the formulas
or did you manually enter them the first time. Perhaps the
equal sign had a space in front.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


> Hello,
> Sometimes when I put a filter on a row, the filters appear but do not work.
> You can select them and they won't show anything. Delete them and put them
> back on manually, they work. Any ideas?
>
> Bill
>
>


 
 
Tom





PostPosted: Sat Oct 29 13:08:42 CDT 2005 Top

Excel Programming >> Filters Possibility the filter hasn't detected the data range or you selected a
multicell range not including the data (only the header for example) when
you applied the filter.

--
Regards,
Tom Ogilvy



> Hello,
> Sometimes when I put a filter on a row, the filters appear but do not
work.
> You can select them and they won't show anything. Delete them and put
them
> back on manually, they work. Any ideas?
>
> Bill
>
>