View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Can't manipulate pivot table

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.


Grrffin wrote:
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.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html