Pivot table picking up wrong data area

[MikeJ100]

Hi, I'm trying to create a new pivot table.

I'm selecting my range for a pivot table from tab called Mike and area A1...F761 on a new worksheet.

However, after selecting my data range, the pivot is actually picking up data from tab Joe area A1..F761 which was previously used for another pivot.

Anyone got any ideas how to get around this?

Thanks in advance for your help

 

[SyedUsman]

If i understand correctly try changing the Pivot table Name from Pivot table options.