cant edit comments

[slm7678]

hello everyone, i hope you all can help.
i have a workbook with several worksheets in it and i can edit the comments on every sheet except one. there are a lot of people using this workbook so i am not sure what was changed but up until yesterday i could edit all of the comments. any help you can provide is greatly appreciated.

TIA

 

[gcue]

Hi

Is your sheet protected?

You can verify by going to tools > Protection

If the sheet is protected, you will have to unprotect it to edit comments.

I hope this helps
This message was edited by gcue on 2002-09-27 07:20

 

[slm7678]

no. there is no protection on the sheet. i realized this morning that some comments (very few) can be edited but the majority cant.

 

[Galto]

Cannot Edit comments

Hello,

I'm also having this problem.

There are a few cells that have comments that I cannot normally edit. The only way I CAN edit them is to show all comments, and find the ones I want to change... then turn the comments off again.

But there are a lot of comments on this sheet and it's pretty cluttered.. sometimes tough to dig thru them all to make a change... and these comment get changed quite a bit.

I see this question wasn't answered waaaay back in 2002.. Anyone out there have a solutio now? I'm running Excel 2000, btw.

Thx!

 

[henno]

How about now in 2010?

 

[msdorahim]

I have same problem of unable to edit old comments, affecting all my .xls & .xlsx files regardless of how many worksheet in the file. I noticed it only affects comments created in the original Excel 2003 (.xls) files before saving it as Excel 2010 (.xlsx). I still cannot edit the old comments after saving the file back as (.xls).

I suspect this happens after my system automatically installs an update somewhere in early January 2011. I cannot control the updates as everything on my PC are under IT administrators' control (remotely).

 

[karabiner8]

I also have the problem. Using Excel 2003 and a file that's been working fine for 6 months. Now I can edit some comments but others on the same worksheet and adjacent to the ones that I can edit do not work. I right-click the cell and pick Edit Comment and nothing happens.

Hasn't anyone figured this out yet?

 

[msdorahim]

I suspect this was caused by one of the microsoft update where they disable comment editing in Excel 2007 or later if the comment is created by older excel versions (ie. 2003). Copying old comment will carry the old attributes, so the pasted comment is also un-editable. My tedious solution is to replace the old comments with new ones if I may still need to edit them in future.

 

[karabiner8]

All comments were created and edited in Excel 2003. For now I am deleting and replacing comments as necessary.

 

[rifpool]

Check my thread....

http://www.mrexcel.com/forum/showthread.php?p=2868255#post2868255