Can't Edit Comments -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I recently upgraded at work from Ofc 2000 to 2003, I don't know if that has
anything to do with it, but some of the Comments won't allow me to edit them.
When you try, the Comment just winks and won't let you access it. They
won't show either when you use the Show All Comments function. It will
display when you select and hover over the cell. Hopefully someone can help
me, I would appreciate it. Thx - Dean
 
Are you sure that they're comments--and not from Data|Validation?

If they really are comments, can you start a new workbook and add/edit comments
there?

(I don't have a response no matter your response, but it may help others.)
 
Dave,
Yes, they are comments, they were comments that I placed in the cells
previously. And yes, I can create new Comments and Edit those. Thx - Dean
 
Dean

I'm betting those are not Comments, but Data Validation messages.

Click on the cell and Data>Validation.

See what you have there.


Gord Dibben Excel MVP
 
I don't have any guess, just some things to play with.

Maybe it's a memory problem.

Try closing every other application and see if that helps.

Try changing the zoom factor to 100% (sometimes it helps with display problems).

Maybe it's a video board problem--can you experiment with the display settings?
(Keep a note of the original settings!)

Maybe start excel in safe mode
close excel
windows start button|run
excel /safe

file|open yourworkbook.xls

And see if that helps.

=====
But if it only happens on that one worksheet, maybe recreating the worksheet
would be in order.
 
Gord,
sorry, it is a note, I even used ASAP utilities to Resize and Reposition
them to their original positions. It has the indicator for the note as well
in the upper right. The note is as I originally placed it in there. I can
edit the cell that each one is in, but I just can't edit the Comment. Thx -
Dean
 
Back
Top