How can I view comments in a pivottable?

D

DaanSolar

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!
 
J

Jim Thomlinson

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.
 

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 missing in field in pivot table 1
The PivotTable field name is not valid (error) 1
How do I display comments (words) as my data in a pivot table? 1
Pivot tables 2
Can you export comments? 2
View Pivot Table Source data as a Data Table 6
How do I print an Excel worksheet to include the comments? 1

Top