I am unable to edit a comment in excel

[Bill]

I have inserted comments in numerous cells on an excel spreadsheet and have
always been able to edit and insert new information, NOW I can no longer edit
any cell that has a comment inserted.
I can still insert new comments in an empty cell and edit them.

 

[Leif]

Bill,

I have the same issue. I see no one answered your post. Did you find a
solution?

 

[Bill]

Leif
No, I still have the same problem, I have asked various so called experts,
but to no avail.
I am glad that you replied I thought that it was me.

Rgds

Bill

 

[Debra Dalgleish]

If the workbook is shared (Tools>Share Workbook), you can only edit
comments that you have added since the file was last saved.

You can delete the existing comment (Edit>Clear>Comments), and insert a
new one.

Could that be the problem?

 

[Bill]

Yes it would create a problem, I can edit by right clicking the cell scroll
down to "show/hide comments" the comment box is then open and I can edit,
when I finnish I then have to go back to "show/hide comments" and close the
box which is just to long, it is much quicker to go to insert and click on
"edit comment".

 

[Leif]

Share Workbook is turned off.

Bills work around also works for me.