| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I view comments in a pivottable?
Hello,
in the original data there are comments added to particular cells. However when I create a pivot table of these data, then I do not see the comments in the pivot table. Even on the lowest level. Can I make these comments visible and how in Excel 2007? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I view comments in a pivottable?
Pivot tables work by creating something called the pivot cache. This is
memory where all of the source data along with all of the aggregations of that data are stored. Comments are not pulled into this memory so there is no way to access them from the pivot table. -- HTH... Jim Thomlinson "DaanSolar" wrote: Hello, in the original data there are comments added to particular cells. However when I create a pivot table of these data, then I do not see the comments in the pivot table. Even on the lowest level. Can I make these comments visible and how in Excel 2007? Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
| Can't view some Comments | Excel Discussion (Misc queries) | |||
| in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Linear Mode
