View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot table - Hide the Data Sheet

Just remember that your client will be able to double-click on the grand
total cell, and recreate all the source data.

If you want him to have the summary, but don't want him to have the
data, copy the pivot table, and paste it as values in a new workbook.

elaine wrote:
hey Jon!

Its working perfectly!! Its Miracle! Thanks!



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