When Pivot Table Refresh with new data line Item should not Change

[Dinesaaa]

Hello,

I use to have a pivot for set of data and provided comments in the next column, when new data added to my data source and when I give refresh pivot table line items getting collapse and due to which my comments in the next column mismatches.

I would like to add the new data into the last line item.

 

[awoohaw]

Are you saying the pivot table gets wider and erases your comments?
If so, that can happen when you add a new data row that creates a new column in the pivot.

 

[Dinesaaa]

Are you saying the pivot table gets wider and erases your comments?
If so, that can happen when you add a new data row that creates a new column in the pivot.

yes, you are correct. I am adding new data to the existing pivot table, once refreshed, below scenario's are happening.

1, As you mentioned, new lines are added if the combinations are same it is adding to the existing line items. but that is not the issue.

2, If the combinations are different it is creating a new line but those lines are reflecting randomly into the pivot line items. I want it to be comes after the existing line items if combination is different.

Apologize for the delayed response!

 

[awoohaw]

Then can you post a mini worksheet with the xl2bb add in (link below). Maybe have two versions of the same data source and pivot, one as the baseline and the comments you have typed, and another with new data in the data source and showing how the comments were removed or not where you want them.