Consulting

Results 1 to 2 of 2

Thread: Sleeper: Pivot Table Too Large

  1. #1

    Sleeper: Pivot Table Too Large

    I get a error on creating a pivot table saying it has too many rows or columns. What are the limits?

    I have 4 columns and 1500 rows. I would like to add another column. Is there a certian number of cells a pivot can handle?

    Thanks,

    Kurt

  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Kurt

    What are you trying to add as row/column items?

    I think there is a limit to the no of columns in a pivot table. I think the no of columns in a pivot table is determined by how many different categories you have in your column item.

    Perhaps you could post some sample data?

Posting Permissions

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