Random clear contents of one cell

[sriche01]

Hello all,

One of my guys in the office works on several spreadsheets. A peculiar phenomenon is developing in which single selected cells are having their contents cleared when he activates the workbook. Many times (but not all) it is the active cell of a multiple cell selection whose contents are deleted. It is usually undoable if he notices it right away. We have talked through possible accidental key strokes that could cause this, but I don't know of a single key stroke that would delete contents of the active cell of a multiple cell selection without leaving the cursor blinking (as backspace does). Any ideas?

I was thinking that maybe we could create a macro that would raise a message box when a cells contents are cleared asking if the user really wanted to clear them.

Perhaps Office needs to be reinstalled.

Office 365/Windows 10

Thanks!

 

[Joe4]

Did you check the "ThisWorkbook" and each of the "Sheet" modules in the VB Editor to see if there is any automated VBA code in those modules?

 

[sriche01]

Did you check the "ThisWorkbook" and each of the "Sheet" modules in the VB Editor to see if there is any automated VBA code in those modules?

Thanks for the reply. I should have noted that this happens in multiple spreadsheets, both macro enabled and otherwise. They are also typically spreadsheets stored on onedrive and accessed by multiple users, though his are the only selections in which the active cell is cleared. Sometimes he will discover the deletion, sometimes another user will discover it and, upon investigation, find that it is the active cell on his station. One time it appeared to be a selection on a worksheet he had not activated as part of a workbook he was in another sheet of. It's just wierd.

 

[Joe4]

Hmmm... That is odd.

If possible, I would recommend first sitting with the user, and watching what he is doing when it happens (sometimes users do weird things, i.e. maybe hitting "F2" or "Delete" accidentally) just to rule that out. And if that does not appear to be the issue, then I would probably try a reinstall.