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.

eileenj wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html