View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Excel 200 Pivot Field Selections Are Locked

What version of Excel are you using?
In which version of Excel was the pivot table created?
Is the worksheet protected?

David From Momentive wrote:
I have opened a worksheet with a pivot table in it. When I try to change (by
clicking in the selection box) in the dropdown field to show only the
selections I want to see I cannot, the boxes are locked. How do I enable the
ability to change these selections



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