Excel Pivots – Unlinking PivotTables from Their Data Source

PivotTables are undoubtedly one of the best features of Microsoft Excel, but they can become tricky once the file size gets larger , So it is not always possible to send a file without compressing it, by sending a program to send

You may not want to always keep your source data as potentially confidential. To share the summary data, you need to unlink the PivotTable and its data sources in some way. Unfortunately, Excel does not have the ability to unlink links, but can achieve the same result in several additional steps

So if you have a PivotChart you have formatted and satisfied with the presentation and level Of the analysis, we can use the real flexible paste special commands and Value command.

1. First select the pivot table cell and press CTRL + C to copy the range, or you can use the Ribbon command by selecting any cell in the table, then

  • On the PivotTable tab, select the option
  • In the Action group – click to select
  • Select Entire Data Pivot
  • If this option is not available, you need to turn on the Enable selection option.

  • Selecting a Cell in a Table
  • On the PivotTable tab, select the option
  • In the Actions group – click to select
  • Check Enabled Enabled or Enabled Enabled

2. When you select a table, the Paste Special dialog box appears. Pressing ALT + ES is a shortcut that applies to all versions of Excel

. In the Paste Special dialog box, select the Value option, and then click OK.

Pivot performance has been unlinked, but if using Excel 2007 or Excel 2010, get this back – we can use two additional steps.

4. Display the Office Clipboard. In Excel 2007 and 2010, click the Start icon in the lower-right corner of the Home-Clipboard group

. When the unlinked pivot is selected, click the item on the Office Clipboard that corresponds to the pivot table copy operation. It will be the last item unless you copy the other items after the last action performed.

The PivotTable now unlinks from its data source, but retains all its original format. You can now easily share summary data with the look and feel of the raw data without the problems associated with the data source and file size