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 !

Ray C wrote:
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 !

Did you know you can double click a data cell in the PT and a new
worksheet will open showing the detail rows from the source table?

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 !

Yes, I already did that and the mystery field is not even there, yet the
records were filtered.

"smartin" wrote:

Ray C wrote:
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 !

Did you know you can double click a data cell in the PT and a new
worksheet will open showing the detail rows from the source table?

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 !

Sounds very strange, Ray.

If you would like to mail me direct with a copy of the workbook, I will
happily take a look.

To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address

--
Regards
Roger Govier

"Ray C" wrote in message
...
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 !