Pivot table reorganizes when it shouldnt!

[MS]

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!

 

[MS]

Btw it is excel 2003 due to company policy or other lame excuse to show that
their it-department isnt up-to-date.

 

[Roger Govier]

Hi

When there are changes in the source data and a Pivot Table refresh is
carried out, there can be new entries included in the revised table.
If the data has been set to be Sorted ascending or Descending by some
particular filed value, then the data will be adjusted to incorporate this.
As such, if you are going to insert comments relating to rows in a PT, you
cannot assume that the data upon which you are commenting will always be in
that same row (or column) location.
Rather than referring to a cell location, you should use the GetPivotData
method to extract the data to sit alongside the comment you have made.

For more information on GetPivotData, take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html

 

[MS]

Thx, Ill see if I can put that function¨to use in my sheet.

Btw the list of part#s and amount is appended to the already existing list
on a daily basis and cleared once a week.

There is no sorting option on the pivot table that I know of?
And any input data isnt sorted either.