Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't manipulate pivot table
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How do I manipulate pivot table report to include percentage of? | Excel Discussion (Misc queries) |