pivot table limitation

T

tchangmian

Hi, when i tried to generate an excel report. It gives me an error
message "Microsoft Excel: Microsoft Excel cannot make this change
because there are too many row or column items. Drag at least one row
or column field off the PivotTable report, or to the page position.
Alternatively, right-click a field, and then click Hide or Hide Levels
on the shortcut menu. Error in generating report. Please contact
Administrator!"
What can i do with this message? Is this the data volumne limitation
for pivot table?
Thanks for your help
 
G

Guest

You have hit one of Excel's limitations.

For pivot tables, there is a limit for the number of item it can
handle/summarise.

For more information, you can refer to the on-line help.
For the Excel 2003 on-line help, type "Excel specifications and limits".
Then choose "PivotTable report specifications".

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com


***************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message when using Pivot Table 3
Can't manipulate pivot table 1
Pivot Table - too many rows/columns error 1
Pivot Table Error-"Microsoft cannont make changes because there are too many..." 1
Pivot table problwm 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Surpressing rows and columns with zero values in a pivot table 1
Pivot Table Error 1

Top