Pivot table error

S

Shawn G.

when updating a pivot table I get this error -

"Microsoft Office Excel cannot make this change because there are too many
row or column items. Drag at least one row or column field off the PivotTable
report, or to the page position. Alternatively, right-click a field, and then
click Hide or Hide Levels on the shortcut menu."

Any idea what is causing this error? or better, How do I fix it? I don't
know how to drag a row or column off the report. Even when I reduce the table
to only show one row or column I get the same error.

Please help - Thanks !!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
sqlite-odbc write conflict 2
Excel does not accept text format! 0
Pivot Table Counting Text Data 0
Pivot Table - Row Label Combination 0
Slicers and Calculated Items in Pivot Table 2
Pivot Tables 0
Pivot table put multiple "Values" in one row but I want them in one column. 0

Top