Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing '0' values in a pivot table | Excel Discussion (Misc queries) | |||
Removing Pivot Table Functionality | Excel Worksheet Functions | |||
Pivot table comments | Excel Discussion (Misc queries) | |||
Comments on a Pivot Table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) |