Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Pivot Tables » Pivot table limit in Office 2007?

Pivot table limit in Office 2007?

Previous | Next
Latest post Mon, Jul 14 2008 8:21 AM by Snwsledge. 2 replies.

  • Sat, Jul 12 2008 10:53 AM

    • Snwsledge
    • Top 200 Contributor
    • Joined on Sat, Jul 12 2008
    • Posts 2
    • Points 26

    Pivot table limit in Office 2007?

    Reply |Contact

     I know that from Excel 97 to 2003 the limit of a pivot table is 8000 elements. What is the limit of Excel 2007 if any?

    Thank you for your prompt answer as this is my first post.

     
    • Post Points: 21

  • Sat, Jul 12 2008 11:57 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: Pivot table limit in Office 2007?

    Reply |Contact |Mark as Answer

    If you mean unique items it is a shade over 1,000,000 with most other things limited by available memory (the size of which (the pool) is also greater in 2007.

    Report filters and value fields in P/T Reports and Charts are limted to 256.

    Finally length of names for MDX names for an item and relational strings are just over 32,000

     

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under:
    • Post Points: 21

  • Mon, Jul 14 2008 8:21 AM In reply to

    • Snwsledge
    • Top 200 Contributor
    • Joined on Sat, Jul 12 2008
    • Posts 2
    • Points 26

    Re: Pivot table limit in Office 2007?

    Reply |Contact |Mark as Answer

     Thank you Mr. hodge.

    Wow, where will it stop?Hmm
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.