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: Newest
  1. 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 No comments
  2. Anonymous
    2015-12-07T04:11:38+00:00

    I am convinced that it is a consequence of the changes made to this 2013 version of excel.

    Wouldn't it be nice if Microsoft actually did something about it?

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2015-12-06T15:07:27+00:00

    I have experienced this problem and it seems to occur in workbooks with many sheets. The cell updated is in the last sheet I was in and appears the last active cell there.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2015-12-06T04:36:07+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

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2015-12-03T02:32:12+00:00

    I am having the same problem since getting Office 2013. I happens rather a lot. I have never had it jump to a cell or another sheet in the same workbook though; always to other workbooks.

    The cell freezes and I have been transported to another workbook. It is important for me to work with multiple workbooks open. I never had this problem with any earlier version of Excel. 

    I believe the cause is inherent in the way workbooks are now 'kept separate' from each other.

    I have noticed that it jumps to the last active cell used in that particular workbook. 

    I have also noticed that this happens an awful lot when the auto save function finishes saving all my open workbooks.

    In the past I turned off the auto save function as I had a habit of saving my work regularly. I have not done that yet with 2013. Maybe that will fix the problem.

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments No comments