How to Freeze the Pivot Table

[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!

[Dave Peterson]

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.

Alan Tang wrote:
>
> 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!

--

Dave Peterson

[Roger Govier]

Hi Alan

Copy the Pivot Table.
Move to another sheet, Paste Special>Formats
Past Special>Values
Send this sheet to required recipients.

--
Regards

Roger Govier


"Alan Tang" <[email protected]> wrote in message
news:[email protected]...
> 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!