excel skips to another workbook for no apparent reason

So annoyed! this exact issue is happening to me virtually every time I edit a cell by clicking into the box above the worksheet then hit enter.

I have the same issue!! in 2019.... seems they still dont fix it ! =( Anyone found the fix?

I have been running Excel in seperate memory spaces to try and avoid this issue for a number of years now by just doing Win+r and runnimg excel.exe /x.

...

Something new however yesterday, I had a single excel sheet open and it would freeze when entering data or moving around. The only way to fix it was to change the tab on the sheet or resize the window. This looked to like the same issue but when a single sheet is open.

Lots of people seem to be helped by running multiple Excel instances, one for each workbook.  But, some of us have the same problem with with multiple windows of the same workbook.  For example, after I enter a value in one cell, I press tab and type another value.  The second value appears in a different window and tab!  Clicking again on the cell where I want the problem does not enable entering a value in that cell.  I have to click somewhere in the second window, then back on the first window with the target cell.

(Running Windows 10 - 64 Pro, and the problem persists from Excel 2013 to Excel 2016.)

Been a problem for years and we have only seen tumble weeds. Beyond poor. Microsoft would rather release another useless new feature than fix their own product.

Microsoft... this is very, very annoying. Here I am in 2019, reading this 2015 post yet the exact same problem is still there. I know for certain that several other people have it too, one uses Excel on a Mac, yet also has the same problem. 

in my case, the issue occurs at random but frequently (when it starts, it will happen very frequently). Its almost always when  I have multiple workbooks open. In may case they are very large spreadsheets. The symptoms are that you will be clicking into a cell to modify the string or formula and the mouse suddenly behaves oddly in the cell. For example, it may be positioned in the middle of the string (or formula) and then as you type, it jumps for no reason to the start of the cell. Nothing you can do will let you type any more in the cell. you can re-position the cursor, but as soon as you type a printable character it wont accept the input. 

It simply wont behave until you press the ENTER key. When you do... opens and it jumps to a cell in one of the minimised workbooks. 

You can then return to the correct workbook and all seems normal until a few minutes later when it will do the same thing again, and again. It happens  very frequently, once it starts to happen. 

Its not the hardware. Previously I was using my Microsoft brand mouse and keyboard but hoping it was a device fault, bought and switched to Microsoft brand WIRED keyboard and  mouse. The issue persists. It also happens just the same on my desktop PC running 64 bit Windows 10 with Office 365 AND it happens just the same on my new AUD$3,000 Surface Pro. 

It is a productivity killer. Its driving me nuts!!!!

I have been a solid Microsoft supporter since the 1980's, but in the last 2 years or so the serious issues with Windows 10 and Excel have repeatedly tested me to the limit. I ran a small software development team for 12 years and we all know that bugs can get in.... but the solution is to fix and TEST, TEST, TEST - meaning test thoroughly to make sure you don't break more than you fix. I cant help but think that the current Microsoft approach is to Fix and test minimally, then release it to see how many other things are broken. Very sad.

Please Microsoft.. fix this issue, surely this one cant be that hard. Its far more important to customer retention than you might think.