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