Issue with hidden field in Pivot table

[D4WNO]

Hi everyone,

I've inherited a report from someone who has left the company and foun
in one of the pivots that there is a field showing at the bottom of th
field list that isn't in the actual sheet that the pivot is linked to
very confused. I've checked for hidden columns on the main worksheet an
there's nothing, nor any hidden lookup tabs. From what I can see it is
lookup as it is basically a team name, based on a username.

I've had a quick look through the VB code but not being entirel
familiar with it I can't see what I'm expecting to see (a lookup list o
a link to one). Could someone please advise where I might need to loo
as the results it is creating are out of sync now and need to b
updated? Totally lost on this one so any help is really reall
appreciated

 

[Spencer101]

Hi everyone,

I've inherited a report from someone who has left the company and foun
in one of the pivots that there is a field showing at the bottom of th
field list that isn't in the actual sheet that the pivot is linked to
very confused. I've checked for hidden columns on the main worksheet an
there's nothing, nor any hidden lookup tabs. From what I can see it is
lookup as it is basically a team name, based on a username.

I've had a quick look through the VB code but not being entirel
familiar with it I can't see what I'm expecting to see (a lookup list o
a link to one). Could someone please advise where I might need to loo
as the results it is creating are out of sync now and need to b
updated? Totally lost on this one so any help is really reall
appreciated.

Hi,

I think for help on this we would have to be able to see the workbook.
Is there any chance of that or is it sensitive data