Categories
Excel

Save or Share Pivot Table Without Source Data

A static copy of the PivotTable is a good option when you want to share it with others but want to keep its data confidential. A static copy does not contain the underlying data that the original PivotTable uses, so you can control what the recipient can see. Another benefit of a static copy is that it has a much smaller file size than the original PivotTable, which makes it easier to send and store.

To create a static copy of a PivotTable in Excel, you can copy the PivotTable and paste it as values into a new location. This way, you’ll have the current data and structure of the PivotTable as a fixed set of values. Here’s how to do it:

  1. To select the entire PivotTable that you want to copy click anywhere inside the PivotTable to activate it.
  2. Go to the PivotTable Analyze tab.
  3. Click the Select drop-down from the Actions group.
  4. Select the Entire PivotTable option to select the entire pivot table.
  5. Press Ctrl+C on your keyboard to copy the pivot table.
  6. Now press CTRL+V to paste the static copy of the PivotTable into the same or different worksheet/workbook.

You can use the Paste Special dialog box and select Values from the list of paste options. You can also choose to paste formatting if you want to maintain the PivotTable’s appearance.

You’ll now have a static copy of the PivotTable in the selected location. This copy will not be linked to the original PivotTable, so it won’t update automatically when the source data changes.

Copy PivotTable as Picture

You can take a static picture of your PivotTable and paste this onto a clean worksheet. This will give you a full-color, formatted snapshot of the original PivotTable to which you can apply any type of formatting you want, without having to worry about the formatting being lost when you refresh the original PivotTable.

One way to copy a pivot table as a picture is to use the Copy as Picture feature:

  1. Select the entire PivotTable that you want to copy.
  2. Go to the Home tab on the ribbon and click down-arrow on Copy icon in the Clipboard group.
  3. In the “Copy Picture” dialog box, choose the options that suit your needs.
  4. Click OK.

Now choose the application where you want to paste the picture, such as Paint, a Word document, or another worksheet, etc., and press CTRL+V or to paste the picture.

PivotTable copies as picture in pasted into the Paint

Pivot Tables

  1. Explaining PivotTables
  2. Create a PivotTable
  3. Automate PivotTable Creation
  4. Save or Share Pivot Table Without Source Data
  5. Extract PivotTable Data Using GETPIVOTDATA