Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.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 |
#2
Posted to microsoft.public.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 "Bill" wrote in message nk.net... 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 |
#3
Posted to microsoft.public.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 "Bill" wrote in message nk.net... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use "OR" in two auto-filters/custom filters? | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Filters | Excel Discussion (Misc queries) |