I have a workbook with several people, each with their own tab plus a 'data' tab, eg, Person1, Person1_Data, Person2, Person2_Data etc etc. I have a PT on each person tab which looks at data on the corresponding 'Data' tab. I also have the tab name in A1 of each person tab.
What I am trying to do is dynamically change the data source of the PT by using a named range. When I define that Named Range I am using:
I am getting 'reference is not valid'
The reason I am trying to do it this way is because I will be adding more tabs (users) and I don't want to have to manually change the data source each time.
Any help would be appreciated.