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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-12-13T16:31:29+00:00

    No, I didn't.  There were a couple of decent suggestions earlier in the string, but I haven't tried any of them.  I sure wish there was a simple remedy, as it is driving me crazy!

    Was this answer helpful?

    0 comments
  2. 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
  3. 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
  4. Anonymous
    2018-12-12T07:58:17+00:00

    Not sure if this is the issue or not, but it might be related to the provided add-ins - analyst tool pack, EURO tool or the Solver. Reason for suggesting this is that I had the situation where I had no workbooks open - i.e. start Excel - open a blank sheet, then file-close. I then open the VBE and I noticed that periodically I saw the selected VBA module change to one of the add-ins, and then focus was transferred to be blank excel.

    Now I have not had time to test this or been able to replicate it. However it might be an idea to try turning off the microsoft provided add-ins and see if this improves the situation.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. 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