Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards in Advanced filter criteria don't work with Excel 2003
Technique: Filtering a list using Advanced Filter (filter-in-place). Using
wildcards used to work in earlier versions of Excel, but it doesn't seem to work in Excel 2003. I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home. The same Excel file will work in Excel 2002 and fail in Excel 2003. It may be fixed in a service pack which I don't have..... ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards in Advanced filter criteria don't work with Excel 2003
Wildcards seem to work in Excel 2003. Can you give an example of the
criteria you're using, and the results you get in the different versions of Excel? Inconceivable wrote: Technique: Filtering a list using Advanced Filter (filter-in-place). Using wildcards used to work in earlier versions of Excel, but it doesn't seem to work in Excel 2003. I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home. The same Excel file will work in Excel 2002 and fail in Excel 2003. It may be fixed in a service pack which I don't have..... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards in Advanced filter criteria don't work with Excel 20
I tried it twice with and without code. On 2 different machines. If you send
me your email, I'll send you a sample if you don't mind. "Debra Dalgleish" wrote: Wildcards seem to work in Excel 2003. Can you give an example of the criteria you're using, and the results you get in the different versions of Excel? Inconceivable wrote: Technique: Filtering a list using Advanced Filter (filter-in-place). Using wildcards used to work in earlier versions of Excel, but it doesn't seem to work in Excel 2003. I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home. The same Excel file will work in Excel 2002 and fail in Excel 2003. It may be fixed in a service pack which I don't have..... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards in Advanced filter criteria don't work with Excel 20
Got it. The problem was including ".value" after the range name for the
criteria in code. Thanks for responding. "Inconceivable" wrote: I tried it twice with and without code. On 2 different machines. If you send me your email, I'll send you a sample if you don't mind. "Debra Dalgleish" wrote: Wildcards seem to work in Excel 2003. Can you give an example of the criteria you're using, and the results you get in the different versions of Excel? Inconceivable wrote: Technique: Filtering a list using Advanced Filter (filter-in-place). Using wildcards used to work in earlier versions of Excel, but it doesn't seem to work in Excel 2003. I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home. The same Excel file will work in Excel 2002 and fail in Excel 2003. It may be fixed in a service pack which I don't have..... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wildcards in Advanced filter criteria don't work with Excel 20
Thanks for reporting what caused the problem.
Inconceivable wrote: Got it. The problem was including ".value" after the range name for the criteria in code. Thanks for responding. "Inconceivable" wrote: I tried it twice with and without code. On 2 different machines. If you send me your email, I'll send you a sample if you don't mind. "Debra Dalgleish" wrote: Wildcards seem to work in Excel 2003. Can you give an example of the criteria you're using, and the results you get in the different versions of Excel? Inconceivable wrote: Technique: Filtering a list using Advanced Filter (filter-in-place). Using wildcards used to work in earlier versions of Excel, but it doesn't seem to work in Excel 2003. I have 2 PCs, one with Excel 2002 at work and one with Excel 2003 at home. The same Excel file will work in Excel 2002 and fail in Excel 2003. It may be fixed in a service pack which I don't have..... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter in Excel 2003 | Excel Discussion (Misc queries) | |||
working in the Advanced Filter in 2003 Excel | Excel Discussion (Misc queries) | |||
Is there an Excel 2003 Advanced Filter Bug?! | Excel Discussion (Misc queries) | |||
Excel 2002/2003 Advanced Filter | Setting up and Configuration of Excel | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |