There are many calculations that I have created in the pivot table to reduce file size when pulling data (e.g. Avg Price = Dollars / Units).

I have just made some updates to my formulas in the first pivot table on tab 1A associated to datatable data1 on tab 1. I now want to copy the pivot table with the formulas accross the other tabs 2A to 10A in order to have all the newly created formulas resident when I change datasources to the correct tables.

However, when I do this the formulas do not copy. I have tried selecting "Entire PivotTable" and copy-pasting, and I have tried copying the entire tab by ctrl-drag(?) and then changing datasource to data2 (e.g.). Neither method works.

I have to believe there is something I'm missing on how replicate a pivot table and change the datasource without all the (new) calculations disappearing.

Any help is appreciated. thanks,