+ Reply to Thread
Results 1 to 14 of 14

Excel gets stuck on a cell

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Excel gets stuck on a cell

    Hello,

    I have a client that enters a lot of data into various spreadsheets, we recently upgraded her computer and along with it upgraded Office to 2013. Since that has happened she has experienced some issues with navigating cells in Excel. What will happen is she will be typing than tabbing or using the arrow keys and all of a sudden the active cell will get stuck on one of them. Arrow keys do not move the cursor to the next cell and the only way for her to fix it is to alt tab to another spreadsheet and then back to the one she was working on. Once that is done it is working fine.

    There seems to be no rhyme or reason to when this happens to her. I have re-installed (used the big one that re-downloads from the web), it has no add-ins on either that are conflicting and I know it is not the keyboard since when I log in through TeamViewer while it is happening I am also unable to move with the arrow keys.

    Anyone see this issue before?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner VA USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,485

    Re: Excel gets stuck on a cell

    Welcome to the Forum Chogreshi!

    I have never seen behavior like this that was not macro-induced, or caused by hitting the Scroll Lock key by mistake. Switching to another file then back again rules out the Scroll Lock key. Does it matter what file it is? Does the Excel file have macros? You say there are no add-ins that are conflicting but maybe try disabling ALL add-ins. If that fixes it add them back in one at a time.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    From what the users has told me the files doesn't matter but it has happened twice on one file that she remembers. I will check to see if it is macro enabled spreadsheet when she is in tomorrow. I know the add-ins are not the issue because she has all the add-ins disabled all the time already.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel gets stuck on a cell

    I sometimes get similar behaviour using Excel 2010 when the file (no macros) is on SkyDrive and I have opened the file by double clicking the file on SkyDrive when File Preview is turned on. In my case, it has something to do with the File Preview as the problem goes away when File Preview is not active.

    Try turning off File Preview if she is using it.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    I'll check to see if its turned on but she is accessing the excel files on the server share

  6. #6
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: Excel gets stuck on a cell

    try unfreezing panes if that's a case
    Rome wasn't built in a day

  7. #7
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    Been a bit since I posted in here but the issue still is happening. I was going to disable her Macros but not all her sheets seem to have them. There is definitely one that the freezing has happened on that does not have any macros on them.
    I don't see any panes being frozen, the cell will be working throughout the day and then randomly it locks to it.

    Any other ideas?

  8. #8
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel gets stuck on a cell

    What do you see for Excel if you right click on the Taskbar, Start Task Manager, Applications? Is Excel "Running"? Is it "Not Responding" etc.?

  9. #9
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    It isn't crashing. If you click off of it and back on to it it works again

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel gets stuck on a cell

    This might be a graphics resources problem. Go to the Control Panel, Performance Information and Tools. Click on Advanced Tools, Adjust the Appearance and Performance of Windows. Click on Adjust for Best Performance.

  11. #11
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    It is already set to Best Performance. This is not a crashing issue as excel itself still works it just gets stuck on that cell

  12. #12
    Registered User
    Join Date
    10-22-2014
    Location
    WICHITA, KS
    MS-Off Ver
    2013
    Posts
    1

    Re: Excel gets stuck on a cell

    Any updates on this? I have almost the exact same issue Excel 2013, the user gets stuck in a cell and can only get out by clicking on another sheet or window. The program does not freeze and logs nothing in the event log. The user is working on network files but I have already checked the network and it is fine. I even added more RAM to the PC and repaired Office. The only things that I can find online that are similar recommend disengaging "scroll lock" and replacing the keyboard (which I have not tried yet). Any help?

  13. #13
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel gets stuck on a cell

    Welcome to the forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

    (link above in the menu bar)

  14. #14
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel gets stuck on a cell

    We did re-installs which only helped for a bit.
    It looks like another tech of mine was able to possibly resolve the issue through running Windows Update. Our client's computer was unable to do Windows Update, once that was fixed it ran through 69 Updates and has been good for 150 days

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  2. cursor stuck in cell
    By NumberCruncher208 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-26-2011, 02:27 PM
  3. Stuck in cell selection
    By stl07 in forum Excel General
    Replies: 3
    Last Post: 09-17-2008, 06:18 PM
  4. [SOLVED] Excel 2003, Windows XP, Stuck in Cell Selection Mode
    By Birdjaf in forum Excel General
    Replies: 1
    Last Post: 06-22-2006, 02:15 PM
  5. Well & Truly stuck on a cell formula!
    By dangleberry in forum Excel General
    Replies: 6
    Last Post: 04-27-2006, 11:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1