Hi,

Please see the attached spreadsheet.

I have created a pivot table using approximately 1,300 rows of data,
which I have reduced to 500 due to the 100Kb limit. When I tried to
move the Kilos field on the Main Report sheet into the data section sop
that I can include sub-totals for each product, I receive the error
message "Excel cannot make this change because there are too many row
or column items".

I have had this problem a couple of other times recently with hardly
any data and although I have managed to bodge something together, I
would like to be able to understand what I can do about this to prevent
it happening in the future. I have tried reducing the data to 500 rows
and studied this Microsoft link ''
(http://support.microsoft.com/default.aspx?id=820742) but it does not
really shed any light. I have also analysed a 1.4 million row query
used by a pivot table that I created recently, and this only gets this
error message when there are too many rows to fit onto the sheet.

What I cannot understand is how such a tiny amount of data will not
work correctly in a pivot table!!

Thanks ever so much for any help!!


Roly


+-------------------------------------------------------------------+
|Filename: Duty Free Meat Forum2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4053 |
+-------------------------------------------------------------------+

--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=487127