software

My source data table is 74 columns and 1,297 rows. I am trying to create a
pivot table with multiple columns from the source data as the quot;dataquot; in the
pivot table. When I try to do this I get an error that says...
quot;Excel cannot make this change because there are too many row or column
items....quot;

Is there a limit on the size?

Any suggestions?
Thanks!
Jenni

I searched Excel Help for quot;limitsquot;. In the Pivot Table section I found this:

PivotTable reports on a sheet:
Limited by available memory

Items in a PivotTable report:
8,000

Row or column fields in a PivotTable report:
Limited by available memory

Page fields in a PivotTable report:
256 (may be limited by available memory)

Data fields in a PivotTable report:
256

Calculated item formulas in a PivotTable report:
Limited by available memory

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JenLquot; wrote:

gt; My source data table is 74 columns and 1,297 rows. I am trying to create a
gt; pivot table with multiple columns from the source data as the quot;dataquot; in the
gt; pivot table. When I try to do this I get an error that says...
gt; quot;Excel cannot make this change because there are too many row or column
gt; items....quot;
gt;
gt; Is there a limit on the size?
gt;
gt; Any suggestions?
gt; Thanks!
gt; Jenni