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.
 
Top