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

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

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

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

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