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: Oldest
  1. 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
  2. Anonymous
    2018-03-26T20:39:12+00:00

    That's good to hear. Glad it worked out for you!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2018-03-26T20:41:15+00:00

    This is more of a workaround to the problem. Unfortunately I don't have an actual fix. Isadore's link below is also very useful if you prefer not using the run -> Excel /x switch each time to open up a new workbook.

    https://support.microsoft.com/en-us/help/3165211/how-to-force-excel-to-open-in-a-new-instance-by-default

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-05-25T15:31:33+00:00

    I have this issue several times per hour. It appears to be an issue that has been reported for over 3 years. 

    I see the solution of using a registry edit create separate instances of Excel, but I also see that this solution only works when you use the file explorer from within Excel. When your files are 6-7 layers deep in the server this is a big time-waster. 

    Microsoft, why is this still an issue 3 years later? What are you doing with your time and our money that's more important than keeping one of your core pieces of business software running properly?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2018-05-25T20:41:00+00:00

    I see the solution of using a registry edit create separate instances of Excel, but I also see that this solution only works when you use the file explorer from within Excel. When your files are 6-7 layers deep in the server this is a big time-waster. 

    We have been using the registry change and the basic symptom has disappeared. I don't know what you're referring to about using file explorer from within Excel. This seems to have affected every Excel instance however launched. We no longer flip from file to file, although there appear to be some other side-effects (presumably, related to things that Excel was able to do with multiple sheets in the same instance). 

    I agree that the lack of any apparent action or acknowledgment in this flagship product is frustrating. But it seems pretty much par for the course in the software biz today.

    Was this answer helpful?

    0 comments No comments