Microsoft Office Tutorials and References
In Depth Information
Unlinking a Pivot Table from Its Source
1. Display the Office Clipboard by clicking the dialog box launcher icon in the bottom right
corner of the Home
2. With the unlinked pivot selected, click the item on the Office Clipboard that corresponds
to the pivot table copy operation.
It will be the last item, unless you copied something else.
After you perform these steps, the pivot table is unlinked from its data source, yet retains
all of its original formatting.