×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pivot Tables "too many row or column items"

Pivot Tables "too many row or column items"

Pivot Tables "too many row or column items"

(OP)
When constructing a Pivot Table, I get the following error "Microsoft Excel cannot make this change because there are too many row or column items.  Drag at least one row or column field off the PifotTable report, or to the page position....

What is the meaning of this?  I need all of the fields on the report. Why is there a restriction, or limit?  What is the workaround?
Kevin.

RE: Pivot Tables "too many row or column items"

Roughly speaking, the resultant pivot table can have a maximum of 256 columns. This is the max width of an Excel sheet. If your selection criteria results in a wider table, then you'll get this message.

If, let's say, you have a worksheet which contains some 1,000 rows and these are transformed into 1,000 columns in your Pivot Table, then it will not work. There is no workaround and your only remedy is to reconstruct the Pivot Table in such a way that the Excel limitations are honoured.

The most common error that can cause this situation occurs when trying to create a PT from data that contains date information, and trying to use the dates as column headers. Regardless of the format in which they are displayed, the dates are kept internally as a number, and even though you see (for example) month/year representation in your original file, each and every date will be put on a different column. Having the time information inside will aggravate this problem.

Good luck,
Engin

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close