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 No comments

130 answers

Sort by: Most helpful
  1. Anonymous
    2019-07-24T19:34:30+00:00

    Well I appreciate your comment. Although it was a little presumptuous to think that this was incorrect, it merely did not tell the entire story. This did indeed stop the issue from happening to me. But why it did turned out to be a secondary behavior issue. I was able to force the issue to occur about 50% of the time in a specific scenario after a couple of days of no issues. You were correct that the timing has to do with typing in the formula bar. I do a lot of typing in formula bars and that is when the issue occurs. I was able to duplicate the issue whenever the cursor was in the center of a formula and I clicked enter (about half the time). Since I was using the enter to navigate to the next cell I would do this often to be done typing and to be at the next cell. So by using different methods to confirm the formula and by keeping the cursor at the end of the equation I have not had the problem duplicate. I cannot say for sure if there are other ways to make this occur, but it was the first time that I was able to repeat an action and see the problem after the action. 100%, nope, but about half the time. I was unable to get it to occur when the cursor was at the end of the formula.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2019-06-18T00:33:11+00:00

    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.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-04-25T14:58:59+00:00

    I have the same issue. It doesn't jump to another cell in the same workbook or worksheet. I think that's a different problem. Mine jumps to a different .xls file that is open and minimized, it might have links, it might not. If I have only one workbook file open, I don't see it happen. I can be quite fast in Excel when I'm working but when that "skip" happens, it slows me down and it's annoying. It takes my thought away from what I'm doing. So if anyone has any real fixes, I'd love to hear about it.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-03-26T13:40:31+00:00

    This solution seems to have resolved the problem for me. I have not had a recurrence of this issue since running each instance of Excel in a separate process. 

    So, this is a very helpful tip. Additionally, I deleted the default Excel shortcut in my task bar and replaced with the shortcut that contains the /x switch.

    I think, though, that it takes away from the point of multi-document-interface in that Excel has a tougher time communicating with itself on cut-and-paste options (that I've noticed). So, MS needs to resolve the issue. It can be a VERY critical issue for those users and companies that depend on Excel (and what company doesn't, at least to some extent).

    Thank you JonathanKung

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2018-01-11T23:22:09+00:00

    I have to agree.  I will be canceling my office 365 subscription next year.  If you don't like the product then quit paying for it is my stance.  Time to look at google sheets and see if that will do the job for me.  Using excel has me concerned I will corrupt my data.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments