EXCEL - How to copy pivot table into another Excel file?

Copper Contributor

In office 2013 I was able to copy pivot table from one file and simply paste it into another file (ctrl-c, ctrl-v).

In office 365 business  I am no longer able to do that.

I can copy and paste into another sheet in the same file but once I try to paste it into another file only the values are pasted.

 

How do I copy pivot table from one Excel file and paste in into another Excel file In office 365 ?

 

0 Replies