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




On Mon, 17 Oct 2005 21:59:22 -0700, "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.