I have ~20 pivot tables in a workbook (let's say workbook A) that I am creating a copy of in workbook B along with the source sheet. But the data source remains the sheet from workbook A. I can manually change the data source to workbook B but the problem arises with the fields.

The pivot tables have row entries 0-150 and (blank) but some of these rows don't have data. They can have data in the future but don't as of now. When I change the data source the blank ones disappear. How do i stop it from happening? I need them all because the cells have dependents. I can't change it to refer to the pivot table dynamically, the file wasn't made by me and there are far too many to change.

So the question is, is there a better way to copy the pivot table over to workbook B from A or is there a way to change the source and retain all rows?

(Using Excel 2016 if it matters)