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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Charles Blaquière" wrote in message
...
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

Max wrote:
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

Afraid not. But perhaps someone else might chime in here.
Hang around awhile.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Charles Blaquière" wrote in message
...
Max wrote:
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