Comment becomes uneditable, cell flashes
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 |
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 |
Comment becomes uneditable, cell flashes
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 |
Comment becomes uneditable, cell flashes
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 |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com