+ Reply to Thread
Results 1 to 3 of 3

Pivot table ROW AREA

  1. #1
    Registered User
    Join Date
    06-22-2006
    Posts
    3

    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

  2. #2
    Franz Verga
    Guest

    Re: Pivot table ROW AREA

    Nel post news:[email protected]
    *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



  3. #3
    Debra Dalgleish
    Guest

    Re: Pivot table ROW AREA

    You can use programming to disable selection. There's sample code here:

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1