Can't manipulate pivot table

G

Grrffin

I look at a huge ss with pivot tables. When I try to manipulate the tables I
get this message "Excel cannot make this change because there are too many
row or column items. Drag at least one row or column field off the Pivot
Table or to the page position. Alternatively, right click a field and then
click Hide or Hide Levels on the shortcut menu."

I have hidden almost all columns and still cannot manipulate. Don't
understand how to drag a row field off the Pivot Table. Running Excel 2000.
 
D

Debra Dalgleish

The following MSKB articles outline PivotTable limits

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

To remove a row field, you can right-click on the field button, and
choose Hide.

Also, try removing any column fields that have lots of items in their
dropdown lists -- you can move them to the page area instead.
 

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

Top