Hi everyone,

I've inherited a report from someone who has left the company and found in one of the pivots that there is a field showing at the bottom of the 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 and there's nothing, nor any hidden lookup tabs. From what I can see it is a 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 entirely familiar with it I can't see what I'm expecting to see (a lookup list or a link to one). Could someone please advise where I might need to look as the results it is creating are out of sync now and need to be updated? Totally lost on this one so any help is really really 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?