View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default comment (with little red triangle) appearing in pivot table

Nothing built into excel to do this.

And wouldn't it be difficult to know which comment to use if there are multiple
comments in for that same field?

happy 111 wrote:

Hi, if i insert a comment in my source data (using the 'insert commment'
function with little red triangle), and then do a pivot table on that data,
is there a way to have the comment appear with the data in the pivot table??

I can understand it would be hard when data cells are summarised or totalled
etc in the pivot table, but where individual data cell infomation from the
data source is presented in the pivot table, i just thought there should be a
way to have the 'comment' to appear as well as the cell information.

I'm using excel 2003

thanks in advance
Peter


--

Dave Peterson