copy pivot table to new workbook/worksheet

Hi,

Maybe you need to Select or Activate the sheet that has the pivot table on it? I'm looking at your code and it appears that it creates a new workbook, then adds "New Report" to cell A1 on worksheet(1), However once that is completed you are asking the script to copy from the "Activesheet"

ActiveSheet.PivotTables("PivotTable2").Copy

Just a thought, Mike

Hi Mike,

As you may have guessed I've pieced this code together from more than one source as I'm not that familiar with VBA yet.

Please would you suggest modified coding that I could try?

Thanks,

Louise