MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Problem


Posted by C Swan on September 27, 2001 8:57 AM

I have a workbook with multiple pivot tables linked to an Access database. I occassionally get the following error message: "Microsoft Excel cannot make this change because there are too many row or column items."

Is there any way to fix this?

Thanks for the help.


Posted by Brian on September 27, 2001 9:39 AM

You might check this out

http://support.microsoft.com/support/kb/articles/Q157/4/86.asp?LN=EN-US&SD=gn&FR=0&qry=pivot%20table%20too%20many%20rows&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97