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-10-01T21:34:52+00:00

    I imported a Microsoft Excel spreadsheet into another package. I've had a problem with these skipping cells for years! So I finally figured there must be something embedded in the cell that was causing the problem. So I highlighted and deleted everything from it, contents, formats the lot. I then reentered the text.The problem has gone!!!!!

    Hope this helps out some other frustrated person!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-09-13T18:00:42+00:00

    Agreed, this is beyond frustrating and quite absurd this thread was created 3 years ago and the same issue persists. I expected a quick google search would help but clearly this issue isn't going anywhere. I've taken to just closing out all workbooks I'm not currently using. Hopefully we can find a resolution.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-09-11T21:49:15+00:00

    ...

    I will also try opening the spreadsheets differently, but it is cumbersome and I know I won't always remember--

    I'm glad I read this, as I was just about to buy a new keyboard, thinking there was a shortcut or hotkey programmed that I didn't know about, or set on accident....

    Regarding opening spreadsheets differently, please note my comments above about the registry change -- which has completely eliminated this problem for us. You don't need to remember anything.

    It is exasperating. I would not expect any changes to occur from the development end, however. This kind of problem has become a very low priority for all software vendors. Most vendors no longer even use professional testers before releases.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-09-11T21:40:08+00:00

    I have the exact same problem, for about 3 years as well.  This happens several times a day and is beyond frustrating--I am hoping that if enough people complain, they will do something to fix this--

    I will also try opening the spreadsheets differently, but it is cumbersome and I know I won't always remember--

    I'm glad I read this, as I was just about to buy a new keyboard, thinking there was a shortcut or hotkey programmed that I didn't know about, or set on accident.  I can't find a way to identity assigned hot keys, either, on a separate note.  That's how frustrating this is--I'm resorting to buying new hardware in hopes of eliminating this problem.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-08-01T18:24:32+00:00

    We haven't seen any issues at all. Everything works the way it used to.

    If you have problems, just clear the setting. It's a single switch being turned on or off.

    Was this answer helpful?

    0 comments