Excel 2000 Pivot Table Limit?

Excel 2000 Pivot Table Limit?

Post by Neil Pen » Sat, 01 Mar 2003 06:02:56

Excel 2000

I have a pivot table based on data on another worksheet. There are around 20
columns and 30 rows, but the pivot table is saying the maximum number of
rows and columns has been exceeded for the pivot table, and to reduce the

Here is the full text of the message I am getting:

"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 pivot table, or
to the page position. Alternatively right click a field , and then click
Hide or Hide Levels on the shortcut menu"

This occurs when trying to refresh  the data in the pivot table. After this
any attempt to do anything with the pivot table gets the error "invalid
pivot table".

What can I do to get the pivot table working?



1. Pivot table in Excel 2000 vs Excel XP

Hi all.

We're developing a solution y which the final analisys of
the data is through a Pivot Table in Excel which
represents data in percentages. We managed to have the
pivot table working on Excel 2000 but when we used Excel
XP the percentages are lost in some situations (showing
then '#VALUE!').

They are only lost when we filter the data picking only
some values of the fields, but not when we select the 'All
[field]' option.

This is becoming very frustrating because we thought the
percentages were allways calculated in the cube so ?why
does changing the client affect the results?.

I'm not sure if the explanation above is very clear but i
need some help with this issue asap.


Alejandro Mezcua

2. DTS - ActiveX Script Transforming rows

3. Excel Pivot Table - Unable to Limit Selection Criteria

4. Make money!

5. URGENT!: Problems refreshing Excel pivot tables with SQL Server 2000

6. ADB-94, International Conference on Applications of Databases

7. Excel Pivot Table: Difference between Office 2000 and XP

8. Date corrupt inside instead of trigger

9. Excel 2000 Pivot Table - Full Data to Replicate Problem

10. Retrieving the properties of Dimensions from Excel 2000 Pivot Tables

11. Excel 2000 Pivot Table

12. About Excel 2000 Pivot Tables ...

13. Using an OLAP Pivot Table in Excel 2000.