In using office 2003 and playing with advanced filter. When I run it I am
getting :
'The extract range has a missing or illegal field name' error message.

All the columns have field names - cant find anything on MS other than for
Excel 97/98 and missing column headings

Any help much appreciated

A

Do you have any hidden columns? Any column headings with unusual characters?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Alex" wrote:

In using office 2003 and playing with advanced filter. When I run it I am
getting :
'The extract range has a missing or illegal field name' error message.

All the columns have field names - cant find anything on MS other than for
Excel 97/98 and missing column headings

Any help much appreciated

A

Hi Dave

No nothing, its just a test worksheet with the following columns and 10/12
rows of data
Surname, Forename, Title, Telephone, Address1, Town, PostCode, AnnualTrips,
Income

Alex


"Dave F" wrote in message
...
Do you have any hidden columns? Any column headings with unusual
characters?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Alex" wrote:

In using office 2003 and playing with advanced filter. When I run it I
am
getting :
'The extract range has a missing or illegal field name' error message.

All the columns have field names - cant find anything on MS other than
for
Excel 97/98 and missing column headings

Any help much appreciated

A

do you have the field names exactly repeated in the criteria section

check with
=field name = criteria field name
if answer is false you would get this type of error.

"Alex" wrote:

In using office 2003 and playing with advanced filter. When I run it I am
getting :
'The extract range has a missing or illegal field name' error message.

All the columns have field names - cant find anything on MS other than for
Excel 97/98 and missing column headings

Any help much appreciated

A

bj

yes I have recreated and did a straightforward Copy.

If I run an Advanced Filter Filter the List in Place, it works Ok, Its
when I do an Advanced Filter Copy to Another Location ( which is on the
same sheet) that the problem occurs.

I am not sure what you want me to check - sorry . As you can tell I am just
getting to grips with Excel

A

when you are selecting your copy to range are yuou selecting one cell or
several cells.
I can get your message if I select several cells, but do not get it if I
select just the upper left cell of the range I want the data to go to.

"Johnny" wrote:

bj

yes I have recreated and did a straightforward Copy.

If I run an Advanced Filter Filter the List in Place, it works Ok, Its
when I do an Advanced Filter Copy to Another Location ( which is on the
same sheet) that the problem occurs.

I am not sure what you want me to check - sorry . As you can tell I am just
getting to grips with Excel

A

Hi
No, in the Copy Range I am just entering a single cell reference J4. If it
helps, the column titles are being copied, but the filtered data isnot

Apologies for change of user name - I am on a colleagues computer
A

Eureka

If I tell Advanced filter to copy to J4 ( which is alongside existing data,
I just get the column titles.
If I tell Advanced Filter to copy to say A19 (below the existing data) it
works perfectly.

Why is that?

Thanks
A

no clue, If I select any cell outside the filtered cells It works for me, I
have 2003 excel

"Johnny" wrote:

Eureka

If I tell Advanced filter to copy to J4 ( which is alongside existing data,
I just get the column titles.
If I tell Advanced Filter to copy to say A19 (below the existing data) it
works perfectly.

Why is that?

Thanks
A

Insert|Name|Define
and delete the name "Extract"

Then try again.

Alex wrote:

In using office 2003 and playing with advanced filter. When I run it I am
getting :
'The extract range has a missing or illegal field name' error message.

All the columns have field names - cant find anything on MS other than for
Excel 97/98 and missing column headings

Any help much appreciated

A

--

Dave Peterson

When I go InsertnameDefine, the only one defined is Criteria

A

If you delete that, what happens?

Johnny wrote:

When I go InsertnameDefine, the only one defined is Criteria

A

--

Dave Peterson

Hi Dave

No joy, still the same. It seems that if I try and copy to the adjacent
column (in this case J) to the existing list, i get the error message,
although the column names are copies, just no filtered data. However if I
set the Copy to say column K, then it works OK

A

Maybe you could describe exactly what you're doing.

Do you select your range before you start Data|Filter|advanced filter? If
you're not, maybe excel is not guessing your range correctly.

The extract name could be hidden (it wasn't for me, though).

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

If you see that name, delete it and try again.


Johnny wrote:

Hi Dave

No joy, still the same. It seems that if I try and copy to the adjacent
column (in this case J) to the existing list, i get the error message,
although the column names are copies, just no filtered data. However if I
set the Copy to say column K, then it works OK

A

--

Dave Peterson