View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Protecting Pivot Tables.

One thought is to simply kill the pivot(s) via paste specialvalues.
That way, there would be no doubt about it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"GEM" wrote:
I have created a Pivot Table, and would like to protect it so no
modifications can be made. I only want for people to select the place at the
very top, the PAGE area.

Is this possible??