Can't manipulate pivot table

G

Guest

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

Similar Threads

Error message when using Pivot Table 3
Pivot Table - too many rows/columns error 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table problwm 2
pivot table limitation 1
Pivot Table Error-"Microsoft cannont make changes because there are too many..." 1
Pivot table wizards 2
Different ways to build Pivot table 1

Top