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

G

gaj

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?
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing comments in a pivot table 1
Data display incomplete after creating Pivot Table 6
Pivot Table - Changes 5
Adding new data within Pivot Table 7
Pivot Table - move Totals column 1
Excel2007 Pivot Table problem 1
formula in pivot excel 2007 1
Move and Copy Pivot Table and Source Data 4

Top