Pivot table ROW AREA
 

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


--
sreenath205
------------------------------------------------------------------------
sreenath205's Profile: http://www.excelforum.com/member.php...o&userid=35663
View this thread: http://www.excelforum.com/showthread...hreadid=554467

Pivot table ROW AREA
 

Nel post
*sreenath205* ha scritto:

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

If you want to ba able to update your pivot table, I think there is no way;
instead you can Copy & Past Special, Values, but in this way the table is
not more updatable.


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Pivot table ROW AREA
 

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