Once you've made a pivot table, the pivot data is stored in a pivot cache in
the workbook. You can completely remove the data sheet, and the pivot table
will be completely functional except for refreshes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"elaine" wrote in message
oups.com...
Hi,

I created a pivot table from a data list. I want to show my client
the pivot table, but not the data which i generated the pivot table.
Is there a way to just send him my Pivot table, without letting him to
know what exactly is in the Data list? (like hiding the worksheet so
that he couldnt unhide it?... using a vba?)

Thanks very much.

Elaine