One specific comment causing problems
Posted by Galfore on January 10, 2002 7:16 AM
I have an excel 97 spreadsheet that locks up Win95 when you move the cursor over one specific comment. In NT 4 you recieved out of memory errors. WHen opening the file in excel 2000 moving the cursor over the one specific comment causes excel to exit. There are several comments on this spreadsheet that work normally. I can remove the other comments but not this one particalur comment. Under tools | options and the View tab in the objects area choose hide all. Is there any alternative ?
Posted by Chris D on January 10, 2002 11:58 AM
How are you trying to delete it ?
Can you just drag an empty cell onto its location then re-construct any data or formula that was previously in the cell ?
HTH
Chris
Posted by Sam S on January 10, 2002 8:18 PM
Galfore
Me thinks there are other posts about this somewhere earlier. What has happened is that your comment has become disassoacited with the worksheet (I don't know why but it happened to me). My solution (and I think it has been suggested in this forum) was to open the spreadsheet, open a new blank spreadsheet, select all cells (click in the top left corner of the spreadsheet)and copy and paste to new blank spreadsheet. This does not bring the comment with it and you can resave the new spreadsheet.
Posted by Galfore on January 11, 2002 7:24 AM
Using the reviewing toolbar under view|comments you can proceed to each one and delete all throught the workbook. I tried before to select the entire spreadsheet and copy to new workbook but loses most of the formating and actually some of the comments too (not all). Did lose problem comment though. If there are no other avenues this may be all I can do.
Posted by Galfore on January 11, 2002 9:36 AM
Deleted the column that contained the comment. This seems to be the best solution for now.
