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 !!!!