Hi!

I need some help on how to remove a drop down menu in a pivot table. I attempted to remove it by unclicking the remove caption and drop downs in the display section of the pivot table options but that removed the drop down menus and the text in that cell. I need the text-the column and row titles- to remain in the cell and the drop down menu of each cell to be removed. Does someone know how to remove the drop down menus?


MariJ