I have a single page worksheet with an embedded pivot table summarising the info on that page. The page needs to be updated weekly and printed with the management reports so I simply copy the worksheet, change the data and away we go. Catch is the new worksheet's pivot table still references the original worksheet.
How can I get it to reference the new worksheet without running the pivot table wizard every time?
Bookmarks