Pivot table limitations of Excel 2000

M

Meghana

I have created a pivot table on excel 2000 by specifying a data in a separare sheet and creating a name. I use this sheet to create my pivot table, when I try to refresh the data it tells me that - "Excel Cannot make the change because there are too may row or column items. Drag atleast 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.
I tried hiding some columns on the pivot table, but that does not seem to help either. Please HELP
 

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

Excel does not accept text format! 0
Pivot table report invalid 0
Pivot Table Data Aggregation 0
Pivot Table Counting Text Data 0
Refreshing some Pivots Tables makes Excel stop or crash 0
Pivot Table Counting Text Issue 0
Excel 2000 Pivot Table Use 0
pivot table missing rows? 0

Top