Disconnecting a Pivottable from its Datasource

  • Thread starter Thread starter Chuck
  • Start date Start date
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.
 
Selecting the entire pivottable and using copy|paste special|values
has always been quick for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The PivotTable field name is not valid (error) 1
Pivot Refresh Error when calling Excel Macro from VB.NET program 0
Pivot Table with MS Access as DataSource 1
View Pivot Table Source data as a Data Table 6
Print tab for each page field in PivotTable 1
Excel VBA For excel 0
EXCEL07 how to use text in a PivotTable value field 1
Pivot Table Data Column Sort Excel 2007 1

Back
Top