I am using Pivot Tables within Excel 2007. I will be distributing this spreadsheet to multiple users to be able review their data within the Pivot Table. I would like them to provide comments in the first available column after the Pivot Table - and based on these comments I will take appropriate action (e.g. disable user accounts, delete certain products, etc). However I have found that when comments are included in the row next to the Pivot Table data, they will stay static and not move with the pivot table data should the user change the Pivot Table variables. I could tell users to review the data using the Pivot Table and then make the appropriate comments in another worksheet, however this will take extra effort. Is there a way to add comments next to Pivot Table data that will stay with that row of data regardless of when the variables within the table are changed?

Many thanks.