| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Max Number Fields/Columns In Pivot Table
Hi
I run Excel 2000 I would like to know the maximum number of fields/colums that a pivot table will hold. I have a pivot table with 10 fields (2 of these are calculated) and it does not seem to allow me to add any more? Thanks in advance John |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Max Number Fields/Columns In Pivot Table
Sorry, it appears I can add another field, the problems seems to be that I
cant add another calculated field, is there a restriction on the number of calculated fields I can add? "John Calder" wrote: Hi I run Excel 2000 I would like to know the maximum number of fields/colums that a pivot table will hold. I have a pivot table with 10 fields (2 of these are calculated) and it does not seem to allow me to add any more? Thanks in advance John |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Max Number Fields/Columns In Pivot Table
Thanks everyone but I found the info I needed.
John "John Calder" wrote: Sorry, it appears I can add another field, the problems seems to be that I cant add another calculated field, is there a restriction on the number of calculated fields I can add? "John Calder" wrote: Hi I run Excel 2000 I would like to know the maximum number of fields/colums that a pivot table will hold. I have a pivot table with 10 fields (2 of these are calculated) and it does not seem to allow me to add any more? Thanks in advance John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
| Pivot Table - How do I count number of columns? | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
