ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   pivot table option is greyed out (https://www.excelbanter.com/excel-worksheet-functions/66159-pivot-table-option-greyed-out.html)

robert

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 ?



All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com