Pivot Table-is it possible to enter comments that "move" with Piv
 

is it possible to enter comments / notes in to a pivot table so that
they"move" as you open and close sections (excel2007), and stay with the
information you are commenting on?

Pivot Table-is it possible to enter comments that "move" with Piv
 

Hi,

No. However, in 2007 there are built-in information tips for every cell in
the pivot table and these adjust as you change the pivot table.

Having said No, above, if the comment was designed to say something that
related to the row and column fields you could create a vba code that rewrote
the comments everytime you refreshed. For example suppose you wanted the
comment for a cell that was in a column field titled month to display the
month name, or indicate the row item, you could do that.


--
Thanks,
Shane Devenshire


"gaj" wrote:

is it possible to enter comments / notes in to a pivot table so that
they"move" as you open and close sections (excel2007), and stay with the
information you are commenting on?