If you don't want people to see that data, then delete those columns
from the source data, and refresh the pivot table.


Rohit wrote:
Hi

i have a pivot table and i have extracted data from another file.

Now i want to hide details of those numbers. that is when i double click it
gives me the full detail of the number. eg names, location etc etc.

i have send my file to other users but i dont want them to know all these
personal deatils.

any help

Thanks




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com