View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_140_] John[_140_] is offline
external usenet poster
 
Posts: 57
Default Pivot table refresh problem

I have a two column pivot table, to the right of that is a column for
comments, outside of the PT, like this:

A B C

PT data PT data Comment1

PT data PT data Comment2

Etc etc



When I refresh my pivot table and add or delete a row to it, the data, of
course, no longer aligns correctly with its respective comment. I can't
make the Comments column a part of the pivot table because you can't change
part of a pivot table (can't make comments). Any ideas on how to align the
comments with their respective rows upon refresh?