Pivot Table

[Dorette]

Dear Reader,

I got a block of data in Excel - sheet 1 (26 columns by
806 rows). I try to create a pivot table on sheet 2 BUT
whenever I try to add more objects to the layout I receive
the following error: "MS Excel cannot make this change
because there are too many row or column items drag at
least one row or column item off the pivot table, or to
the page position..."

What can I do to display all the data?
Please help, this is rather urgent!
Thanks

 

[Dave Peterson]

From a post by Tom Ogilvy:

http://support.microsoft.com/?kbid=157486
XL97: Limits of PivotTables in Microsoft Excel 97 (Q157486)

http://support.microsoft.com/?kbid=211517
XL2000: Limits of PivotTables in Microsoft Excel 2000 (Q211517)

http://support.microsoft.com/?kbid=291061
XL2002: Limits of PivotTables in Microsoft Excel 2002 (Q291061)


above should give you some insights on what the limits are and how you might
work within them.

Regards,
Tom Ogilvy

 

[Dorette]

Thanks a million, just the kinda info I was looking for!