Import Load Multiple Calculated Fields from one Pivot table to another

[half]

Hello,

I'm using Excel 2007.

I have 60 calculated fields from a pivot table that I would like to use on a new data source. The new data source has 20 new columns that original did not have. The existing calculated fields from the original pivot table will work with the new data set and I will need to add another 10 calculated fields to deal with the new columns.

Is there a vba macro that will allow me to load the 60 calculated fields into the new pivot table at one time? Or better yet, load all 70 calculated fields? I have all equations from the list formulas feature. I just need a way to load all of them at the same time into the new pivot table.

(I did try changing the data source from the original pivot table to the new data source, however, this always crashes excel. Adding one column to the original source seems to work. But adding 20 with new column headings into a pivot table with 60 calculated fields, fails every time. Even tried doing named ranges and tables.)

Of course I can load each equation one at a time, but that will be an hour of my life that I can't get back.

Thank you in advance.