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

Dealing with a Pivot Table (when I don't want to) 0
Converting URLs in comments to Markdown-formatted links 2
How to have two tables on same line? 1
Power Pivot. Yikes. 0
Autonumber field in Excel that behaves the same as Access 0
Pivot Table cell values 1
Write back from pivot table 1
Write back from pivot table 0

Top