You can use programming to disable selection. There's sample code he
http://www.contextures.com/xlPivot12.html
sreenath205 wrote:
Hi All
If i add a field to pivot tables ROW area it appears as a drop down.How
to remove that drop down?ie all options should be shown no option for
filtering should be given.
Thanks in Advance
Sreenath
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html