Can't Edit Comments -

[Dean]

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]

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

[Dean]

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
>

[Gord Dibben]

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

On Thu, 15 Dec 2005 06:57:03 -0800, "Dean" <[email protected]>
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]

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

[Dave Peterson]

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

[Dean]

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 Data>Validation.
>
> See what you have there.
>
>
> Gord Dibben Excel MVP
>
> On Thu, 15 Dec 2005 06:57:03 -0800, "Dean" <[email protected]>
> 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
>

[siddowens123]

I am in the same boat as OP,

I am NOT using a shared workbook, though the workbook is on the server. Other people on separate computers have opened it and added comments of their own, though not in the particular cell I am having trouble with.

It shows the red "comment" in the corner of the cell, and when i hover over the cell it shows the comment, but when i try to edit the comment, nothing happens. The comment box doesn't even pop up.
Everything was working fine until about a week ago when i noticed that some cells with comments could not be edited (others in the same workbook CAN be edited). My workaround is to write down what i had in the comment and then delete the comment and add a new one, then re-type what i had in the comment along with any additional text i want. super annoying.

I think this is a bug on MS Excel's part. Why would I be able to edit some cells with comments, and not others in the same workbook? Nobody is working in the workbook the same time I am.

[arlu1201]

siddowens123,

This is a 7 yr old thread and you are not likely to get a reply. Please start a new thread.