Pivot Table refresh error.

W

wel

I got the following when trying to refresh my pivot table:

Microsfot 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, or to the page position. Altenatively, right click a field,
and then click Hide or Hide Levels on the shortcut menu.

Any one pls?
 
M

Mladen_Dj

Seems you went above Excel limits. You can read about Excel pivot limits in
help. Did you try to do as Excel advice to hide levels, or drag fields from
table?
 
W

wel

Will try. Many thanks.

Mladen_Dj said:
Seems you went above Excel limits. You can read about Excel pivot limits in
help. Did you try to do as Excel advice to hide levels, or drag fields from
table?
Click to expand...
 
Top