Hello,

I have created a pivot table and the dropdown lists for the column and
pages work fine, I can deselect and reselct items I want to hide or
display. However on my rows if I deselect an item it the gets removed
from the drop down list altogether !

Is the a setting somewhere I need to change ?


--
Fullam
------------------------------------------------------------------------
Fullam's Profile: http://www.excelforum.com/member.php...o&userid=33363
View this thread: http://www.excelforum.com/showthread...hreadid=533004