Disconnecting a Pivottable from its Datasource

C

Chuck

I have a Pivot table connected to a very large data set. Frequently I want
to send the pivot table report by email, but the file is very large. Is
there an easy way to disconnect the pivot table from its underlying data set,
and essentially have a small flat table to send?
The cut & "paste special" process I use now is not very efficient.
 
D

Dave Peterson

Selecting the entire pivottable and using copy|paste special|values
has always been quick for me.
 
Top