I've a pivot table with about 1600 rows, 12 columns, of items requiring
action, and one of the columns in the source data contains the owner of the
action.
I've included the owner of the action on the pivot table so that I can see
how many actions each person has.
The problem is that for one particular name, the cell on the pivot table
displays as 'Trans' rather than pulling through the name from the source
data. If I change the cell data in the original sheet to seemingly any other
value, it pulls through OK, but when this specific name is entered, 'Trans'
appears in the pivot table for that entry.

Can anyone help me understand why this is and hopefully resolve it please ?
Thanks.