Copy Pivot Table Data as Text

Most of the time we can come into a situation where we need to send a Pivot Table summary report but we do not want to include or send original data.

Here is the SOLUTION

Excel doesn't have a command to unlink a pivot table, but it does have a flexible Paste Special command. Using that command, with the Value option, should do the job:

1.        Select the pivot table cells and press Ctrl+C to copy the range.

2.        Display the Paste Special dialog box. Pressing Alt+ES

3.        In the Paste Special dialog box, choose the Values option, and click OK.

The pivot table is unlinked.

Keep Reading keep Learning

Sanjay Bakshi

mesanjaybakshi@gmail.com