How to Freeze the Pivot Table

  • Thread starter Thread starter Alan Tang
  • Start date Start date
A

Alan Tang

Hello:

Is it possible to Freeze the Pivot Table Data? I would like to give the
table data only. The raw data will be delete to min. the size.

Thanks a lot!
 
Just select the whole table
edit|copy
edit|paste special|values

I'd clean up all the stuff I needed to first. (removing subtotals is easier
while it's still a pivottable.)

And just a hint.

Copy that worksheet with the pivottable first. Then when you screw up the
formatting, you can start over with the already existing pivottable--you don't
have to start from scratch.
 
Hi Alan

Copy the Pivot Table.
Move to another sheet, Paste Special>Formats
Past Special>Values
Send this sheet to required recipients.
 
You must log in or register to reply here.

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

Pivot Table Help! 1
Export Pivot table 1
Pivot table report invalid 0
Turning Data into a Table 1
Adding a Formula as a data variable in a pivot 5
How to base a pivot table on another pivot table? 3
Consolidate Pivot Tables/Cache using Excel 2003 1
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1

Back
Top