i guess that the old comment cannot be edited, yet since you need to
re-comment using a new excel version, maybe a New tool with a Macro wiz_pro
can help you add the new comment in the SAME cell..<old comment to remain for
file history is not a bad idea in a new version IF you can add a New one
also!
"Nothing is impossible" ...try also to post in the ms excel programming
discussion group...I believe they have something for you.
--
regards,
dribler


"jsky" wrote:

I have Excel 2007, but have saved my worksheet as both native and excel
97-2003 in order to see if it fixes my problem. My problem is I have created
several comments on over 100 different cells and many (not all) of them are
unable to be edited. I seem to just be ignored. you can float over the cell
and see the comment but you cannot edit it.

Don't think it matters but I am using Autofilter. I can say that many of
the comments that I CAN edit are up on my title row where the autofilter is.
If I delete the comment from the cell and manually create a new one in that
cell, i CAN edit it.

Does any of this have to do with converting it from Excel 2007 back to
saving as Excel 97-2003? I can't undo it.

Help!