Change Source Data with a Pivot Range excel 2010

[philb99]

Hi - is there a simple way of knowing where the Table range is looking at if the file path is long and the file path is not in the same file - when I click in I cant see and then the file path stats changing

Thanks

 

[philb99]

Any thoughts / help re my Pivot Table / Table Range query please