Sheet freezes when trying to add Comment

ISSUE:  In GSheets - when trying to add a "comment" to a cell, the Sheet freezes.  This is happening to only ONE row in the Sheet.  All other cells/rows are fine when doing this function in this same Sheet.

HERE'S WHAT HAPPENS: I right click to add a Comment.  Click on Comment in the selection pop-up.  Sheet freezes.  Error box pops up that says "Page Unresponsive, Aw, Snap!  Something went wrong while displaying this webpage. Error code: RESULT_CODE_HUNG".  Options given are Wait, Exit Page or Reload. 

I have tried all options given to resolve.  Re-opened Sheet numerous times.  Restarted computer.  Copied and pasted "clean" cell contents from the same Sheet and from other Sheets into the affected row/cells.

Nothing is working and the row continues to be "infected".  Any advice as to what has gone wrong and how to fix it?

My next steps are to cut/paste special the row contents to a fresh sheet.  Delete the row in the original Sheet, insert a new row, and see if I can copy/paste special the contents back into the new row in the original Sheet.  But I don't want to have to do this and would love to know what has happened and if there is a resolution!

Ty!

Solved Solved
1 6 3,600
1 ACCEPTED SOLUTION

I didn't try that - but ty for the suggestion!  I would try it,  but here's what happened - I decided to wfh the next day - and when I opened the same s/s, the comments were working!  When I return to work next week after the holiday, I'll see if the s/s continues to work.  What a mystery!

View solution in original post

6 REPLIES 6
Top Labels in this Space
Top Solution Authors