ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disconnecting a Pivottable from its Datasource (https://www.excelbanter.com/excel-discussion-misc-queries/206776-disconnecting-pivottable-its-datasource.html)

Chuck

Disconnecting a Pivottable from its Datasource
 
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.


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com