I have a worksheet for work tracking purposes named "Template" with empty table and pivot table on the same sheet referencing to the empty table. Once I make a copy of the sheet to track new month the pivot table still references to old "Template" sheet instead of the new created sheet. I tried to remove worksheet reference from data source table (to make it relative to the same sheet) of pivot table but this seems to be impossible. Only possible solution is to changing the data source to point Pivot table to new sheet each time I copy the sheet but I find this workaround very stupid. (I want to share this document with my colleagues and make it as much simple as possible.)
Is there any sane solution avoid referencing source table from other sheet or simply bind the Pivot Table to the same worksheet?
Thank you in advance.
Bookmarks