| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Overcome col. limit?
It appears the Pivot Table will only allow me four columns of data which is
restricting my ability to offer a meaningful report/entry for our users.... Is there a way to overcome this....up till now I have been using the wizard to create the pivots... Many thanks Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table - Overcome col. limit?
Pivot tables have limits, but there is not explicit limit to 4 columns. It
is a combination of unique values for rows and columns. Some articles of interest: http://support.microsoft.com/?kbid=211517 XL2000: Limits of PivotTables in Microsoft Excel 2000 http://support.microsoft.com/?kbid=157486 XL97: Limits of PivotTables in Microsoft Excel 97 http://support.microsoft.com/?kbid=157488 XL97: Using Server Page Fields in PivotTables http://support.microsoft.com/?kbid=104308 XL: Optimizing PivotTable Performance http://support.microsoft.com/?kbid=162476 XL97: Purpose of the PivotTable Optimize Memory Option -- Regards, Tom Ogilvy wrote in message ... It appears the Pivot Table will only allow me four columns of data which is restricting my ability to offer a meaningful report/entry for our users.... Is there a way to overcome this....up till now I have been using the wizard to create the pivots... Many thanks Jason |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table - Overcome col. limit?
for completeness:
http://support.microsoft.com/?kbid=291061 XL2002: Limits of PivotTables in Microsoft Excel 2002 (Q291061) -- Regards, Tom Ogilvy wrote in message ... It appears the Pivot Table will only allow me four columns of data which is restricting my ability to offer a meaningful report/entry for our users.... Is there a way to overcome this....up till now I have been using the wizard to create the pivots... Many thanks Jason |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table - Overcome col. limit?
Thanks Tom....damn, is there perhaps an 'add-on' that soups up the pivot
tables and allows me to get in at least four more columns? "Tom Ogilvy" wrote in message ... for completeness: http://support.microsoft.com/?kbid=291061 XL2002: Limits of PivotTables in Microsoft Excel 2002 (Q291061) -- Regards, Tom Ogilvy wrote in message ... It appears the Pivot Table will only allow me four columns of data which is restricting my ability to offer a meaningful report/entry for our users.... Is there a way to overcome this....up till now I have been using the wizard to create the pivots... Many thanks Jason |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table - Overcome col. limit?
Not if you are exceeding the limits.
You might restructure your data to have fewer unique rows. -- Regards, Tom Ogilvy wrote in message ... Thanks Tom....damn, is there perhaps an 'add-on' that soups up the pivot tables and allows me to get in at least four more columns? "Tom Ogilvy" wrote in message ... for completeness: http://support.microsoft.com/?kbid=291061 XL2002: Limits of PivotTables in Microsoft Excel 2002 (Q291061) -- Regards, Tom Ogilvy wrote in message ... It appears the Pivot Table will only allow me four columns of data which is restricting my ability to offer a meaningful report/entry for our users.... Is there a way to overcome this....up till now I have been using the wizard to create the pivots... Many thanks Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit access in a pivot table | Excel Worksheet Functions | |||
| combine multiple workbooks? overcome 255 character limit? | Excel Worksheet Functions | |||
| Pivot table cell limit | Excel Worksheet Functions | |||
| is there a limit to the # of rows in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot table limit | Excel Worksheet Functions | |||
Linear Mode
