limits on number of rows in a pivot table

deuxo · Mar 26th, 2002, 11:02 PM

When I create a Pivot table I get an error message saying I have too many rows or columns. My layout for the table has only 1 data field, 7 rows and 0 columns. Is there some option I need to set or limit on the database I am using.

Dave Hawley · Mar 26th, 2002, 11:52 PM

Hi Deuxo

Here are the specs for Pivot Tables. You may need to drag to the Page field

PivotTable report specifications
Feature Maximum limit
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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 11:02 PM	#1
deuxo New Member Join Date: Mar 2002 Posts: 13	When I create a Pivot table I get an error message saying I have too many rows or columns. My layout for the table has only 1 data field, 7 rows and 0 columns. Is there some option I need to set or limit on the database I am using.

Mar 26th, 2002, 11:52 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Deuxo Here are the specs for Pivot Tables. You may need to drag to the Page field PivotTable report specifications Feature Maximum limit 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