Removing comments in a pivot table

C

CMEknit

A colleague managed to insert comments in a pivot table, but he's now unable
to remove them. Can they be removed and, if so, how?
 
T

trip_to_tokyo

EXCEL 2007

Try the following:-

1. Launch Workbook.

2. Turn off column that has Comment(s) in it in PivotTable Field List.

3. Go to cell that has comment in it / right click / Delete Comment.

4. Turn column removed at number 2. above back on.

5. Save file.

6. Close and re-launch to make sure that comment(s) removed (they were in
test in test I conducted).

If my comments have helped please hit Yes.

Thanks.
 

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

How can I view comments in a pivottable? 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Data missing in field in pivot table 1
Pivot tables 2
Data display incomplete after creating Pivot Table 6
Pivot Table-is it possible to enter comments that "move" with Piv 1
How do I display comments (words) as my data in a pivot table? 1
Pivot table filter list - listing irrelevant subcategorys 1

Top