"John Smith" in source data appears as "t k" in PivotTable

[Rachel Garrett]

PivotTables are wonderful, but this one has me stumped:

I have a table which includes the field "Task Resource", where
individual names are listed. There is a PivotTable generated from this
list, which groups task by owner, phase, etc.

It works great, except that one engineer -- let's call him "John
Smith" -- appears as "t k" in the Task Resource column of the
PivotTable.

When I go back to the source data, his name is John Smith. It is a
text string, not a formula.

When I use the PivotTable to drill down, his name in Task Resource
column is John Smith.

I've added and removed Task Resource many times, to no avail.

I searched across the entire spreadsheet for anywhere else the "t k"
might appear. Nothing.

I recreated the PivotTable, and it still does this.

Any suggestions?

 

[JP]

You probably need to post a sample of your data. Needless to say you
should also be searching the "Task Resource" column for the term "t
k".

--JP

 

[ShaneDevenshire]

1. This could be done with custom formatting, but it seems like a strange
thing to do. Select a range in the data source that contains John Smith and
note the content of the Formula Bar. Then choose Format, Cells and see if a
custom format has been applied. Repeat these steps in the pivot table with
one of the cell displaying the t k.

2. Check to see if any columns of the data source are hidden. Maybe there
is a nickname column.

3. Do a Find on t k within the data source. Do a Find in the pivot table
using John Smith.

4. Is the pivot table really picking up the Name field from the source
data. Field names in pivot tables can be different that in the source data.