Hi!

I have a pivot table based on a range of part#s and amount in two columns on
sheet1, I create the pivottable in sheet2 and in sheet3 I add information
that I get on the parts.

The list in sheet1 increases daily with a varying amount of part#s and
corresponding stock amounts, some part#s which already exist but the pivot
table correctly only keeps 1 instance of that part# and adds the new amount,
which is ok since sheet3 then keeps its consistency, the pivot table is
presently covering 200 rows in sheet1.

The problem is, that at about 50 items on sheet1 the pivot table seems to
decide to reorganize the data so that the commenst added to the part#s and
amount in sheet3 no longer corresponds to each other!

The questions are....

1) Wtf does the pivot table suddenly decide to reorganize data!?

2) Is there a way to stop it from doing so?

Any help appreciated...thx!