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

Filtered view of Visio Chart 0
How to print cell # while printing in excel 0
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added a 0
Removing comments in a pivot table 1
PivotTable - Filter Row 0
How do I print an Excel worksheet to include the comments? 1
How do I display comments (words) as my data in a pivot table? 1
The PivotTable field name is not valid (error) 1

Top