What does this error message mean: "Pivot tables cannot have more than 200 columns."
I have specified 5 columns and 9 rows with 5 calculated values. If I try to add another column and calculated value, I see this message. The columns are fields that have Yes/No values, The calculated values are convert Yes values to number 1s and sum. In the resulting Pivot Table, I see a count of all the Yes values, a count of all the No values, and the totals. How can adding another column trigger the error?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
skcombs
What does this error message mean: "Pivot tables cannot have more than 200 columns."
I have specified 5 columns and 9 rows with 5 calculated values. If I try to add another column and calculated value, I see this message. The columns are fields that have Yes/No values, The calculated values are convert Yes values to number 1s and sum. In the resulting Pivot Table, I see a count of all the Yes values, a count of all the No values, and the totals. How can adding another column trigger the error?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.