Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: limits on number of rows in a pivot table

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I create a Pivot table I get an error message saying I have too many rows or columns. My layout for the table has only 1 data field, 7 rows and 0 columns. Is there some option I need to set or limit on the database I am using.

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Deuxo

    Here are the specs for Pivot Tables. You may need to drag to the Page field

    PivotTable report specifications
    Feature Maximum limit
    PivotTable reports on a sheet Limited by available memory
    Items in a PivotTable report 8,000
    Row or column fields in a PivotTable report Limited by available memory
    Page fields in a PivotTable report 256 (may be limited by available memory)
    Data fields in a PivotTable report 256
    Calculated item formulas in a PivotTable report Limited by available memory



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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