Pivot Table Limits

microsoft_excel

Limitations of Pivot Table Reports

Pivot table reports have limitations that you must be aware of. Although some of these limitations remain constant regardless of available system memory, others are dependent on available system memory:

  1. The number of row fields you can place in a pivot table is only limited by available memory.
  2. Starting with Excel 2003, the number of unique items in a row field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique row items in a row field.
  3. You can have no more than 256 column fields (may be limited by available memory).
  4. Starting with Excel 2003, the number of unique items in a column field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique column items in a column field.
  5. You can have no more than 256 page fields (may be limited by available memory).
  6. Starting with Excel 2003, the number of unique items in a page field is limited to 32,500. Prior Excel versions have a limit of 8,000 unique page items in a page field.
  7. You can have no more than 256 data fields.
  8. The number of calculated items you can use in a pivot table is only limited by available memory.
  9. The number of pivot table reports on a spreadsheet is only limited by available memory.

facebook-comments

New! Comments

Have your say about what you just read! Leave me a comment in the box below.

Share this page:

What’s this?

Enjoy this page? Please pay it forward. Here’s how…

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

<a href=”http://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a><a href=”http://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a>hiddensecretsbookcoverhiddensecrets_online

Excel Courses for Business Professionals

How to sleep and lose weight

Copyright © advanced-excel.com 2007 – 2019. All Rights Reserved. Privacy Policy

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.

advanced-excel.com is in no way associated with Microsoft