Hi
I have some data which I want to sort and group together. I figured out
that using pivot table would give me a nice format and save me the
trouble of updating even though I don't need the summarise function of
pivot tables.

I managed to create a pivot table with 7 fields and I actually hid the
'Total' column as it's useless to me. The problem comes in when I want
to increase the range of the data. I got the error message below:

"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."

Currently, I only using 150 rows and 11 columns.
Can anyone help?
Thanks


--
Muffin
------------------------------------------------------------------------
Muffin's Profile: http://www.excelforum.com/member.php...o&userid=36093
View this thread: http://www.excelforum.com/showthread...hreadid=558733

Hi,

I'm receiving the same error. It means that, in the pivot table layout
step, you put too many fields in either the row or column section.
Apparently, you can only have so many.

Not sure if that helps you...I'm still trying to figure out what other
options there are for reporting my data.

"Muffin" wrote:


Hi
I have some data which I want to sort and group together. I figured out
that using pivot table would give me a nice format and save me the
trouble of updating even though I don't need the summarise function of
pivot tables.

I managed to create a pivot table with 7 fields and I actually hid the
'Total' column as it's useless to me. The problem comes in when I want
to increase the range of the data. I got the error message below:

"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."

Currently, I only using 150 rows and 11 columns.
Can anyone help?
Thanks


--
Muffin
------------------------------------------------------------------------
Muffin's Profile: http://www.excelforum.com/member.php...o&userid=36093
View this thread: http://www.excelforum.com/showthread...hreadid=558733