excel skips to another workbook for no apparent reason

Anonymous
2015-01-24T17:08:03+00:00

Quite often when I try to make an entry into a cell excel appears to freeze.  If I hit the enter button it skips to a different workbook.  There are no links between the two workbooks.  This has been happening for some time and is very annoying.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

130 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-12-13T16:16:46+00:00

    I'm having the same issue.  It's been happening for a couple years.  I just tolerated it.  Did you ever get a solution?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-12-12T08:24:44+00:00

    it might be related to the provided add-ins - analyst tool pack, EURO tool or the Solver. 

    I have had all those disabled those for some time now.

    During my investigation of this bug (which started yesterday), and considerable time before that, I have not had a single Add-in activated.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-12-12T07:34:28+00:00

    I have this problem too, and it was reproduced perfectly by a macro-enabled worksheet which was a great annoyance for all the users of my tooling. This particular macro worksheet performs the following on startup:

    1. Workbook_Open event launches function
    2. Function opens form and minimizes macro-enabled worksheet
    3. Bug is produced

    My solution now is the following:

    Private Sub Workbook_Open()<br><br><br>Dim wkbActive as Workbook<br><br><br>Set wkbActive = ActiveWorkbook<br><br><br>...<br><br><br>Call wkbActive.Activate<br><br>End Sub

    (I have also inserted this or similar code at every other window operation and workbook open operation)

    To me it seems that this bug is that Excel fails to pass focus to the next workbook when a workbook is minimized, and/or that it can pass focus to a minimized workbook. Obviously microsoft should address this ASAP, but in the meanwhile those of us who use macro-enabled workbooks might fix it ourselves by manually handling workbook activation.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-12-05T16:48:19+00:00

    I am also able to reproduce the problem now following similar steps. Resize a column then select a new cell, at which point excel becomes "locked" until I press enter and then it shifts focus to another excel window. It only happens if another excel window is minimized. If all excel windows are opened but visible or not the problem does not seem to happen.

    Very frustrating that it seems to be a known and reproducible problem that has not been fixed for a long time...

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-11-28T21:03:32+00:00

    I have been able to reproduce this issue several times in a row by performing the following actions with more than one spreadsheet open:

    1. Resize a column that has data present
    2. Enter data into the column that was just resized and press "Enter"
    3. I am now in "bug mode" wherein I can't enter text until I press "Enter" again, at which point one of the other open spreadsheets pops up over the one I'm working on.  

    I was able to reproduce this bug at will until I closed the specific sheet that was popping up when I pressed "Enter."   Once that sheet was closed, I was not able reproduce the issue, even with other sheets open.   There is no linkage between the sheet I'm actually working on and the one that popped up when pressing "Enter" and I can't figure out how the buggy relationship starts, but this issue occurs (for me) maybe a dozen times per day.

    Was this answer helpful?

    0 comments