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.