Pivot Table Comment Field

  • Thread starter Thread starter robertjtucker
  • Start date Start date
R

robertjtucker

I am wanting to put a comment field in a pivot table, so when some on
sees something on the table they can put a comment as why it is there
A free form type thing. I know that if I put a field in that is blan
and it puts (blank) in all the cells in the field, if you change th
word blank to what ever it changes all the same thing to what you typ
in that field or cell. So the only thing I could think of was to pu
numbers in the column prior to converting to a pivot table like 1-150
so they would all be unique so I can have a comment field. Is ther
some other way to do this?
Thanks for the help,
Bo
 
It is for many users, and I am not sure that everyone would know to loo
for the red tag on the cell for comments. The rest of the spread sheet
that are used here all have a column marked comments and they ar
probably used to that. Of course I made this reall nice pivot tabl
that makes things really easy, and I need a comment field.
Thanks for the help,
Bo
 
You could add text to any adjacent cell (not part of the pivottable), but then
if you rearrange that pivottable, your text may not make much sense. (If the
users don't know to look for comments, maybe you could copy|paste special over
the pivottable and make it just data so it can't be rearranged??)

You could turn on the comments so that they're always visible?

Tools|options|view tab.
 
I like the way inserting the comments works, putting the name in an
everything but if there is comments in cells right above or below the
overlap and you can't read them if you alow them to be viewed all th
time. Like you said if it is in adjacent cells out of the pivot the
the text gets jumbled if you sort or use the drop boxes. Can you grou
them with a part of the pivot table so the cells that are not in th
pivot will move with the data in the pivot.
Thanks for you input Dave,
Bo
 
I don't think you can tie those adjacent cells to something in the pivottable.
There are just so many things you can do that I would think it would be
impossible to do it automatically.

If you can pick out a unique value, maybe you could put the notes in another
worksheet and use =vlookup() to retrieve that "comment" into the adjacent cell.
(But that, too, would depend on what you did to that pivottable.)
 
I think What I'll do is in my data table I'll create a column fo
comments. In the cells below it I'll put "Enter Comments Here 01" an
do a fill in the range so it'll have a unique entry for every field s
when it creates the pivot table and they enter comments it will no
change the fiel in the pivot table to all the same comment. Make sense
it does in my head at least
 
Back
Top