PDA

View Full Version : Copy Pivot Table From One Workbook To Another



jo15765
04-28-2016, 01:03 PM
I have a pivot table that is in workbook, and I want to bring the EXACT format/fields/drilldowns etc into a new workbook to use with a different data source (I want to keep both pivot tables in tact).

Is there a quick way to copy the exact pivot table into a new workbook and change the data source?

I tried to move the worksheet into a new workbook and change the data source, but some of the grouping is lost when that occurs.