pivot table

[Debra Dalgleish]

If the workbook contains hidden data, the recipient will be able to view
it fairly easily, by cracking the passwords. For information on Excel's
security, see J.E. McGimpsey's site:

http://www.mcgimpsey.com/excel/removepwords.html

You could create a copy of the workbook, with only the data they should
see, and send that copy.

 

[kumar]

how to prevent a receiver of Pivot table opening hidden page tabs??

Pls help