Dear Roly,

I can not download your file.

There is no limit. You can have 1300 records (rows) or 13,000. It is only
limited to the nos of rows in Excel which is 65536.

You can use the add-in. E-mail me at jawadasgharali@hotmail.com & i can sedn
you the add-in. It will be a big help.

Regards

Jawad

"roly" wrote:

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