Can't Edit Comments -
 

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

Can't Edit Comments -
 

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.)

Dean wrote:

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

--

Dave Peterson

Can't Edit Comments -
 

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

"Dave Peterson" wrote:

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.)

Dean wrote:

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

--

Dave Peterson

Can't Edit Comments -
 

Dean

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

Click on the cell and DataValidation.

See what you have there.


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 06:57:03 -0800, "Dean"
wrote:

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

Can't Edit Comments -
 

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.

Dean wrote:

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

"Dave Peterson" wrote:

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.)

Dean wrote:

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

--

Dave Peterson


--

Dave Peterson

Can't Edit Comments -
 

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

"Gord Dibben" wrote:

Dean

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

Click on the cell and DataValidation.

See what you have there.


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 06:57:03 -0800, "Dean"
wrote:

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