Comment becomes uneditable, cell flashes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Blaquière - 04 Oct 2007 15:38 GMT

I have a worksheet I've been using for years, which has started misbehaving.

I created a complex formula and wanted to document it with a cell comment. I
can insert a comment correctly the first time, but if I try to edit or
resize the comment, it disappears and the cell flashes repeatedly.

- Why is this happening?
- How can I work around this, and be able to edit/resize the comment?
- Should I be worried about possible corruption?

Thanks!

Charles

Reply to this Message

Max - 05 Oct 2007 07:58 GMT

Perhaps you might want to try the "Open and repair" option (in xl2003)

Sequence:
File > Save as .. (give it a back-up name)
Close the file
File > Open
Navigate to and select the "back-up" file in the "Open" dialog
Click on the tiny dropdown to the right of "Open" button

> choose "Open and Repair.."

Good luck

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I have a worksheet I've been using for years, which has started
>misbehaving.
[quoted text clipped - 10 lines]
>
> Charles

Reply to this Message

Charles Blaquière - 09 Oct 2007 00:22 GMT

> Perhaps you might want to try the "Open and repair" option (in xl2003)

I forgot to mention that I'm using Excel 2000... thanks for the advice; any
other thoughts?

Charles

Reply to this Message

Max - 09 Oct 2007 04:33 GMT

Afraid not. But perhaps someone else might chime in here.
Hang around awhile.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>> Perhaps you might want to try the "Open and repair" option (in xl2003)
>
> I forgot to mention that I'm using Excel 2000... thanks for the advice;
> any other thoughts?
>
> Charles

Reply to this Message