Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table option is greyed out
2 questions on pivot tables:
1. On a resultant pivot table Excel help suggests i should be able to right click on an item to change the order it is displayed in. All I get is the 4 options greyed out (move to beginning, move up etc..). Any idea why ? 2. I seem to be limited on the amount of fields I can drop into the row fields, I wanted to create a pivot table report from the data I had but it wouldnt let me go greater than about 7, is there a limit ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
pivot table - New Data | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |