Comments in Cells disappear after time

[Guest]

A colleague has a spreadsheet with lots of comments in the cells and
apparently after a while the comments 'disappear'. Does anyone have any
ideas why this happens? Could it be there is a maximum number of comments,
or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel
2003 depending on the user.
Thanks for your help.

 

[Debra Dalgleish]

Comments don't normally disappear on their own. Perhaps your colleague
is accidentally deleting the rows or columns in which the comments
occur. Or comments could disappear if another cell, with no comment, is
dragged onto a cell with a comment.

 

[Ron]

I had the same problem of disappearing comments when one worksheet
reached almost 700 comments.

My solution was to divide the worksheet into two worksheets with about
350 comment boxes in each. No more problems.

Ron