How to copy a pivot table without the data

Tip: How to copy a pivot table without the data

In this video, we’ll look at how to copy and paste a pivot table without the underlying data.

When you create a pivot table with source data in a worksheet, Excel quietly creates a hidden data cache that travels along with the pivot table.

If you copy and paste the pivot table into a new worksheet, remember the data will come along with the pivot table in the hidden cache.

Duration 
2:45
Author 

Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *