Pivot Table - Too many rows/columns??

J Lowe · Mar 21st, 2002, 10:43 AM

Is there a way around the error message that 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 pivottable, or to the page
position. Alternatively, right click a field, and then click hide or hide levels on the shortcut menu."

I have data consisting of 3818 rows and 7 columns. I need all of the data, so I can't cut any of it out.

Is there a way to get MS to accept the amount of data and give me my Pivot Table???

Thanks,
Jason

Henry · Mar 21st, 2002, 11:30 AM

Hi:

You're where I was a couple of weeks ago. Now I have a new problem with PT re: my recent PT Post.
Have you tried moving the Field to the Page Area (layout)? I did that for Data I absolutely didn't need and it worked ok. Also, you might try a Pivot Table feeding off a PT which is still new to me.

Mike

J Lowe · Mar 21st, 2002, 12:13 PM

Thanks, Mike, for the suggestions.

I wound up eliminating a field that I did not absolutely have to have and was able to make the PT work. I'll have to look at the PT within a PT and see what that's all about. Sounds intriguing.

Thanks again,
Jason

Mark W. · Mar 21st, 2002, 12:16 PM

Quote:

On 2002-03-21 09:43, J Lowe wrote:
Is there a way around the error message that 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 pivottable, or to the page
position. Alternatively, right click a field, and then click hide or hide levels on the shortcut menu."

I have data consisting of 3818 rows and 7 columns. I need all of the data, so I can't cut any of it out.

Is there a way to get MS to accept the amount of data and give me my Pivot Table???

Thanks,
Jason

The maximum number of items in a PivotTable is 8,000. "Items" are highlighted in yellow on the PivotTable diagram viewable in the Excel Help topic for "Parts of a PivotTable".

J Lowe · Mar 21st, 2002, 12:31 PM

I guess there's no way to get around that, eh?

I'll have to go look at that info.

Thanks for the information.

Jason
Dallas, TX

Henry · Mar 21st, 2002, 07:28 PM

One good thing about dragging the fields you don't use to the page area is they're always on the desktop, which means you and your customers can get to them real quick without needing any PT training. I keep all my fields there and just move them around when I need them--very convenient.

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

Mar 21st, 2002, 10:43 AM	#1
J Lowe New Member Join Date: Feb 2002 Posts: 27	Is there a way around the error message that 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 pivottable, or to the page position. Alternatively, right click a field, and then click hide or hide levels on the shortcut menu." I have data consisting of 3818 rows and 7 columns. I need all of the data, so I can't cut any of it out. Is there a way to get MS to accept the amount of data and give me my Pivot Table??? Thanks, Jason

Mar 21st, 2002, 11:30 AM	#2
Henry Board Regular Join Date: Mar 2002 Location: Mike T. Posts: 180	Hi: You're where I was a couple of weeks ago. Now I have a new problem with PT re: my recent PT Post. Have you tried moving the Field to the Page Area (layout)? I did that for Data I absolutely didn't need and it worked ok. Also, you might try a Pivot Table feeding off a PT which is still new to me. Mike

Mar 21st, 2002, 12:13 PM	#3
J Lowe New Member Join Date: Feb 2002 Posts: 27	Thanks, Mike, for the suggestions. I wound up eliminating a field that I did not absolutely have to have and was able to make the PT work. I'll have to look at the PT within a PT and see what that's all about. Sounds intriguing. Thanks again, Jason

Mar 21st, 2002, 12:31 PM	#5
J Lowe New Member Join Date: Feb 2002 Posts: 27	I guess there's no way to get around that, eh? I'll have to go look at that info. Thanks for the information. Jason Dallas, TX

Mar 21st, 2002, 07:28 PM	#6
Henry Board Regular Join Date: Mar 2002 Location: Mike T. Posts: 180	One good thing about dragging the fields you don't use to the page area is they're always on the desktop, which means you and your customers can get to them real quick without needing any PT training. I keep all my fields there and just move them around when I need them--very convenient.