Comments disappeared from one sheet, any ideas?

**natko** · 03-23-2011, 08:08 AM

Hello to all,

I'm brand new here, but hopefully will get some help as this really confuses me.

All comments I had on one worksheet (I use 7-8 in that workbook) just disappeared overnight, does anybody know how that can happen? Is there any way to put them back...I assume no. Luckily, I have data to fill them back in but it would take me days...

I don't use macros in that file, nor I shared it. Nor I deleted them by myself of course, don't know even how to do it all by once.

Got 3345 rows in that worksheet, might that be a problem?

Also, it's not the case that they collapsed, just those red triangles disappeared and I can normally put comments back in again.

Thanks for any kind of clue/help,
Natko

**royUK** · 03-23-2011, 08:14 AM

Welcome to the Forum.

Have they disappeared, or is the sheet not showing the little red triangle?

**natko** · 03-23-2011, 08:36 AM

Originally Posted by royUK

Welcome to the Forum.

Have they disappeared, or is the sheet not showing the little red triangle?

Thanks.
Entire sheet is not showing those triangles and of course when I hover with pointer nothing happens. Cells are like they never had comments, I can normally use option "Insert Comment"

**royUK** · 03-23-2011, 08:48 AM

Can you attach the workbook, mark the cells that had comments.

Are comments OK in other workbooks?

**natko** · 03-23-2011, 08:56 AM

Thanks for answer.

Comments are fine in other workbooks and also worksheets of that workbook.

It's a bigger file, only that sheet had over 3000 rows. I can copy it, remove other sheets and put only part if needed?