Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
We have been happily using auto filter on a spreadsheet for months. Recently
we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
To remove advanced filters do datafiltershow all
-- Regards, Peo Sjoblom "Peter" wrote in message ... We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
Hi,
Thanks but "show all" is greyed out -- Peter "Peo Sjoblom" wrote: To remove advanced filters do datafiltershow all -- Regards, Peo Sjoblom "Peter" wrote in message ... We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
Is the workbook shared?
-- Regards, Peo Sjoblom "Peter" wrote in message ... Hi, Thanks but "show all" is greyed out -- Peter "Peo Sjoblom" wrote: To remove advanced filters do datafiltershow all -- Regards, Peo Sjoblom "Peter" wrote in message ... We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
yes - it sits on the public drive on our network.
-- Peter "Peo Sjoblom" wrote: Is the workbook shared? -- Regards, Peo Sjoblom "Peter" wrote in message ... Hi, Thanks but "show all" is greyed out -- Peter "Peo Sjoblom" wrote: To remove advanced filters do datafiltershow all -- Regards, Peo Sjoblom "Peter" wrote in message ... We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
Hi,
There are few possibilities: 1. Clear the list range and Criteria range text boxes in the Advance Filter diialog box and then click OK 2. If you have defined named ranges, then Clear the list range and Criteria range named ranges from the text boxes in the Advance Filter diialog box and then click OK. 3. In the "Unique Record" checkbox, click to clear the selction. Note: Show All will work only for AutoFilter. Challa Prabhu For more information: Challa Prabhu We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
-- Peter "Peo Sjoblom" wrote: Is the workbook shared? -- Regards, Peo Sjoblom "Peter" wrote in message ... Hi, Thanks but "show all" is greyed out -- Peter "Peo Sjoblom" wrote: To remove advanced filters do datafiltershow all -- Regards, Peo Sjoblom "Peter" wrote in message ... We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter - how do you get it to go away
Hi Challa,
If I try to clear the list range I get a "reference is not valid" message. ie it will not let me clear the box. Unique record checkbox and criteria range are blank -- Peter "challa prabhu" wrote: Hi, There are few possibilities: 1. Clear the list range and Criteria range text boxes in the Advance Filter diialog box and then click OK 2. If you have defined named ranges, then Clear the list range and Criteria range named ranges from the text boxes in the Advance Filter diialog box and then click OK. 3. In the "Unique Record" checkbox, click to clear the selction. Note: Show All will work only for AutoFilter. Challa Prabhu For more information: Challa Prabhu We have been happily using auto filter on a spreadsheet for months. Recently we noticed that the auto filter wasn't covering the bottom few rows. After a bit of searching around I found advanced filter which had information in the "list range" box. The auto filter was only working to the extent of the range in the advanced filter. How do I get rid of this range. If I delete it it says reference is not valid. If I type in a bigger range to cope with growth in the spreadsheet it does not retain it. The spreadsheet is used by several users on a network. I tried copying the data to a new spreadsheet but the problem has just followed. Any ideas? -- Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |