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.

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

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.