Weird behaviour when inserting a new row ()

AOB

Well-known Member
Joined
Dec 15, 2010
Messages
632
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
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!)
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

rlv01

Well-known Member
Joined
May 16, 2017
Messages
1,804
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

Well-known Member
Joined
Dec 15, 2010
Messages
632
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
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

Well-known Member
Joined
May 16, 2017
Messages
1,804
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 
Solution

AOB

Well-known Member
Joined
Dec 15, 2010
Messages
632
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Reboot did the trick... ;)
 

Forum statistics

Threads
1,176,033
Messages
5,901,024
Members
434,866
Latest member
nachoabasile

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top