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! Go to 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!