Can't edit a Comment, not protecting, not sharing

[Guest]

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!

 

[Guest]

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.

 

[Guest]

I didn't mean to imply that I was EVER using the old version of Excel. This
has all been done in the last week using Excel 2007. The only difference is
(and this MAY have nothing to do with it) during this fiasco I have been
saving as a native Excel 2007 file and as Excel 97-2003 file. But why would
it happen to some cells and not to others?

I will try to post it elsewhere as you suggest.

And can you elaborate on that idea you had?
Thanks.

 

[Guest]

I am pertaining to a "hopeful" macro that can embed new call-out comment on
the same cell that may have an old call-out comment...
meaning IF the first comment was made on a file say under xlversion#<A>
then such comment shall exist on the conversion of file say under
xlversion#<B>
and the macro can "hopefully" insert on the same cell another call-out
comment box...
and so on and so forth for every file conversion..
For me, Comments are made not only for the data on the cell but also for the
cells' relative behaviour to with the whole sheet <dimension wise>.