Change pivot source when generating new workbook

[Darren_workforce]

I have a file setup with macros to sort out and filter data that I paste in weekly from a few raw reports. After the transfer of data, the macro files "beautify" the data so it's more presentable to my superiors. I have a couple pivot tables that I just refresh and all is well. I run 1 final macro file that generates a brand new .xlsx files that carries over the majority of the macro file's tabs. This is how I avoid altering the macro file or end up sending a report that's bigger in size than it needs to be. My problem is that the pivot tables that carry over into the new worksheet, if anybody were to attempt to refresh them (even accidentally), are still referencing the source data located in the macro file located in the company's U drive. So if they were to accidentally be refreshed, it would pull data that could potentially be months old and overwrite the newest data within the weekly report I create.

What needs to happen so that when the new .xlsx file is created, the pivot tables reference the data contained within their own file instead of trying to reference data from the separate macro file?

Thank you in advance for any assistance available!

 

[GlennUK]

When you carry over the PivotTables to the new workbook, move them and move their source tabs over, instead of copying, then they will point within the new workbook.