C CMEknit Mar 18, 2010 #1 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?
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 Mar 18, 2010 #2 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.
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.
