Paste-special-value hides comments

Question

When I have a comment associated with a cell with a formula and I copy that cell, then paste-special-value into it, the comment becomes hidden somewhat.

(If I copy another cell and paste-special-value into the cell with a comment, there is no problem.)

What I mean is:  the red comment indicator disappears, and the comment no longer appears when I hover the mouse cursor over the cell.  However, if I click on Insert Comment, it behaves like Edit Comment, which does not appear in the drop-down menu, BTW, even though Delete Comment does appear in the menu.

I can work around this nuisance by saving and closing the file, then re-opening it.  Then the red comment indicator reappears, and the comment appears when I hover the mouse cursor over the cell.

Does anyone know of a way to correct the misbehavior without saving/closing/reopening the file?

---

I tried going to another worksheet, then returning to the problem worksheet, to no avail.  I also tried minimizing and re-maximizing the worksheet window, again to no avail.  And I tried creating a new workbook, then returning to the problem workbook, to no avail.

I have Excel 2010 SP1.  I tried to update Office 2010 (SP3), just in case the problem has been fixed already.  But I grew impatient with the "check for latest updates" process.

Is there a way to update just Office 2010?  Even better, just Excel 2010?

I tried "check for updates" in Excel Help.  That took me to the web page that gets "stuck" in the "check for latest updates" process.

(I presume it is really just time-consuming, not really stuck.)

Answer 1

I see the same behavior in Excel 2007.

Running this macro:

Sub dermal()

Dim s As Shape

For Each s In ActiveSheet.Shapes

s.Visible = True

Next

End Sub

will at least allow you to see the comments, although it does not restore the red flag or the correct mouse-over behavior.