Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PivotTable Row Fields (Excel 2000 SR1 (v 9.0.3821))

    Hi

    I have a peculiar problem with showing some information from a Text field
    in a PivotTable in the ROW area of the table.
    This is a 'Remarks' column in my database

    The problem is that Excel gives the error --
    'Too many Row/Column items. Drag one or more fields into the page position or Hide it'

    This is because I have already summarised the data using 4-5 other fields.
    And Excel also 'summarizes' the Remarks column - which is not necessary for me.

    Is there a way to show the Remarks 'outside' the summarized area of the table ?
    I couldn't find any such option in Excel 2000.
    Does XP have any workaround ?

    At the moment, I'm forced to write code
    which enters a lookup to the Remarks in my database
    and adds it to the right of the PivotTable

    Thanks :-)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PivotTable Row Fields (Excel 2000 SR1 (v 9.0.3821))

    I don't think that Excel has a built-in way to do what you want. The code you wrote is probably the best workaround.

  3. #3
    Lounger
    Join Date
    Jan 2002
    Location
    Mumbai, India
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PivotTable Row Fields (Excel 2000 SR1 (v 9.0.3821))

    Thanks Hans ...

    Too bad for me that it's not possible... :-(
    But I can live with it...

Posting Permissions

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