You can use programming to prevent fields from being dragged to a
different location, or off the pivot table. There's sample code he

http://www.contextures.com/xlPivot12.html

PK wrote:
I have created a Pivot Table and graph. The graphs will be available for use
by my coleges to interigate data. The table/graph consists 4 Pivot Table
Fields, can I fix some of the fields so that cant be removed however my
collegue will need to be able to add further fields


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html