Extract range error

Topic

New Reply

I am trying to do an extract of data based on criteria. It has worked fine until I made a minor change.
Now I get an error saying:
The extract range has a missing orillegal field name.
I have deleted all the range names and re-created them but keep getting the same error.
Help Please!!

Thanks,

itconc

Reply | Quote

Replies

What was the minor change you made?

It would help if you could attach a copy of the workbook with sensitive information removed or altered.

Reply | Quote

What was the minor change you made?

It would help if you could attach a copy of the workbook with sensitive information removed or altered.

Thanks to both of you.
Before I got ready to attach the file, I re-did all the column headings and lo and behold that was the problem. The minor change was to add a data series and adjust all the dynamic ranges I had.
Anyway, all is working again.
Thanks again!

Reply | Quote

It sounds like one the headings in the header row has been deleted.

Steve

Reply | Quote