Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max columns in a pivot table (Excel 97 SR-2)

    Is there a maximum number of columns allowed in a pivot table?

    I am tracking response levels from a TV message and have a number of fields that I would like to analyze and trend on a weekly basis. The messages aired every week during the year. I need to do a trending over a full year (i.e. 52 weeks) but by pivot table stops at 51 weeks plus the total column.

    Any help would be appreciated.

    Thanks
    JB

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Max columns in a pivot table (Excel 97 SR-2)

    JB,

    Yes there is. See the Microsoft knowledge base articles:

    "Limits of PivotTables in Microsoft Excel..."
    Q157486 - XL 97
    Q211517 - XL 2000

    If you are using Internet Explorer you can go directly to the articles by
    just entering the following in the address bar: mskb Q157486

    Regards,

    Jim Cone
    San Jose, CA

Posting Permissions

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