View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Comment becomes uneditable, cell flashes

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