Comments in Cells disappear after time
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 in Cells disappear after time
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 |
Comments in Cells disappear after time
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. |
All times are GMT +1. The time now is 10:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com