Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comment (with little red triangle) appearing in pivot table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comment (with little red triangle) appearing in pivot table
Thanks Dave,
I understand it would be difficult in cases where multiple comments exist due to multiple cells being the source of information in the pivot, which is why i asked "where INDIVIDUAL data cell infomation from the data source is presented in the pivot table...." I imagine many people have the desire for comments to carry through to Pivots and wondered if No one is aware if/how excel can carry a 'comment' through to a pivot, how brilliant minds out there may achieve a similar result...ie to carry a comment / detailed words etc through to a pivot? thanks for looking and thinking about this for me Peter "Dave Peterson" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comment (with little red triangle) appearing in pivot table
Actually, I've never seen a request in any of the newsgroups for this
feature--that doesn't mean that the number of people who would want it is small--maybe just not vocal <bg. Can you put the comment in a cell in the same row, then use that as a row/column field, too? I don't have another suggestion, though. happy 111 wrote: Thanks Dave, I understand it would be difficult in cases where multiple comments exist due to multiple cells being the source of information in the pivot, which is why i asked "where INDIVIDUAL data cell infomation from the data source is presented in the pivot table...." I imagine many people have the desire for comments to carry through to Pivots and wondered if No one is aware if/how excel can carry a 'comment' through to a pivot, how brilliant minds out there may achieve a similar result...ie to carry a comment / detailed words etc through to a pivot? thanks for looking and thinking about this for me Peter "Dave Peterson" wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
comment (with little red triangle) appearing in pivot table
Thanks again Dave. Yes thats the best thing i could think of too.
"Dave Peterson" wrote: Actually, I've never seen a request in any of the newsgroups for this feature--that doesn't mean that the number of people who would want it is small--maybe just not vocal <bg. Can you put the comment in a cell in the same row, then use that as a row/column field, too? I don't have another suggestion, though. happy 111 wrote: Thanks Dave, I understand it would be difficult in cases where multiple comments exist due to multiple cells being the source of information in the pivot, which is why i asked "where INDIVIDUAL data cell infomation from the data source is presented in the pivot table...." I imagine many people have the desire for comments to carry through to Pivots and wondered if No one is aware if/how excel can carry a 'comment' through to a pivot, how brilliant minds out there may achieve a similar result...ie to carry a comment / detailed words etc through to a pivot? thanks for looking and thinking about this for me Peter "Dave Peterson" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change the color of the triangle indicating a comment | Excel Discussion (Misc queries) | |||
How do I keep my name from appearing in the comment box in excel | Excel Discussion (Misc queries) | |||
"red" Triangle in Comment Indicator- make bigger?? | New Users to Excel | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
the red triangle that indicates comment has dissipeared while the. | Excel Discussion (Misc queries) |