Pivot Table refresh error.

  • Thread starter Thread starter wel
  • Start date Start date
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?
 
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?
 
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...
 
You must log in or register to reply here.

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

Pivot Table Help! 1
Pivot table report invalid 0
limitation of pivot tables in excel 2000 2
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1
Refresh CubeFields for existing Pivot Table on OLAP cube 1
Pivot Table Refresh 2
Pivot Tables in Excel 2007 vs 2003 1
Pivot Table Trauma 1

Back
Top