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
    2016-04-18T16:36:27+00:00

    You asked:

    1. What is the exact issue are you facing?

    Type in a cell and press enter - the text is not in that cell but can be found in another worksheet - apparently the prior worksheet that was active before switching to the sheet where the text is being entered.

    1. Did you try any troubleshooting steps?

    Tried several which is how I found it appears to be the prior active worksheet (which could be in another workbook). Note that it is random and not easy to recreate.

    1. What is the version of Excel 2013 are you using?

    I've had this with Excel 2013 and now in Excel 2016 (i keep current on updates so it was several releases of each and is still occurring).

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-04-18T02:54:56+00:00

    I've had this problem ever since I was given Excel 2013 at work. I tolerated it for a while but it drives me nuts now. It didn't happen in the decades of Excel past, why is it happening now?

    I think the problem is big enough to deserve a proper response from Microsoft, why aren't they responding? It's obviously a defect. No other program does this. Does Microsoft not care, or is it a conflict at fundamental level in Windows that it can't resolve easily?

    Grae.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-03-01T23:11:13+00:00

    John from NZ,

    So you are now the third person on this thread with the same exact problem. (cshannon on 8/21/15 and me).

    I think that you are the first to note that it jumps to the last active cell on the other workbook.  I think that is the case with me also.

    John R

    Add me to the list. I've had this problem for a while and only just decided to search to see if there is a solution. I initially thought it had to do with running macros (seems to be the most common trigger for me) but it happens during normal operation as well.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2016-02-09T21:57:56+00:00

    John from NZ,

    So you are now the third person on this thread with the same exact problem. (cshannon on 8/21/15 and me).

    I think that you are the first to note that it jumps to the last active cell on the other workbook.  I think that is the case with me also.

    John R

    This exact thing is happening to multiple users of mine as well. Running Windows 7 with both Office 2013 and Office 2016 (from O365)

    Still waiting for a resolution from Microsoft....

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2016-01-19T17:21:21+00:00

    FYI, I have the same issue as described. I don't have any other insights to add right now, because this often happens when I am presenting in a meeting, and I don't have time to troubleshoot. I am on Windows 7 with Office 2013.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments