Weird behaviour when inserting a new row ()

[AOB]

I have a colleague who suddenly developed this strange behaviour last night, across ALL his Excel workbooks.

If he tries to insert a new row, nothing happens. The new row doesn't appear, no warning or error, just - nothing happens. But - if he saves the workbook, closes it and then reopens it, the inserted row is present.

I would liken it to having Application.ScreenUpdating = False in VBA but a) these are vanilla workbooks with no code and b) I went into the VBE and tested Application.ScreenUpdating and it is most definitely True.

Another oddity is, if he deletes a row, the row doesn't disappear unless he scrolls down, so that the deleted row moves off-screen, and then scrolls back up again.

It's really bizarre and not something I've ever come across myself (and I've found plenty of Excel weirdness in the past) It also seems to have started happening quite suddenly (i.e. mid-session), which is making me wonder if an erroneous shortcut key combo might have been hit which changed some kind of setting somewhere. But can't for the life of me think what setting would cause behaviour like that.

Has anybody else come across this kind of thing and were you able to determine the cause / solution?

(Edit : Aargh meant to put the Office version in the title - it's Office 2013!)

 

[rlv01]

When that kind of thing happens at night the best thing to do is shut down your PC, go to bed, and see if the problem still exists in the morning.

 

[AOB]

Yeah that was my initial reaction alright - some kind of memory / resource issue on the local machine. I had presumed a reboot had been made as a matter of course (when in doubt, turn 'er off and turn 'er back on again!) but evidently that hasn't been tried yet so I will suggest that and see what happens. Just thought it was unusual as I've seen Excel foul up due to resource issues before but it usually catches up with itself in-session. Never seen a situation where changes could only be viewed by saving / closing / reopening before.

Have a great weekend @rlv01

 

[rlv01]

The fact that it happened to ALL his workbooks at once points to 'wierdness' likely resolved by a reboot. Sometimes excel just has strange interactions with other applications. Recently I had my keyboard arrows just stop working for no reason. A reboot resolved the issue.

 

[AOB]

Reboot did the trick...