There are no hidden columns in the source sheet, and the source range is
A1:Q62410.

From A to Q implies 17 fields. Yet, there are 18 fields in the PT's
available fields list.

Another thing I tried was this:
I opened the source sheet and added filters for each column on the first
line. When I clicked on each drop-down list on each column, none of them have
the options that appear when I click the mystery field's drop-down on the PT.
So I really don't know where this field is getting its data from (in the PT)?

This mystery field is one of two column fields in the PT (if that helps).

"Roger Govier" wrote:

Hi Ray

Is column R hidden on the Source sheet?
Right click on the PTPT WizardBack and what is the source range?

--
Regards
Roger Govier

"Ray C" wrote in message
...
I have a pivot table in a worksheet that is based on the data from another
worksheet in the same workbook. The data worsheet has 17 columns (from A
to
Q) with 62410 lines worth of data.

When I view the pivot table's list of available fields, I have 18 fields,
not 17. So I naturally thought that someone added a calculated field. But
when I looked, there is no extra calculated field. This extra field only
has
about 5 values and I don't know where these 5 values are coming from.

Aside from the data source or calculated fields, I'm wondering if there is
another way of adding a new field in a pivot table. Can anyone help me?
I'm
stumped. This workbook was given to me. I did Ctrl-F to find the 5 values
in
the data worksheet and they are NOT there in any column.

Help !