Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Excel Calculation Hangs until mouse is clicked

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Calculation Hangs until mouse is clicked

    Hi All,

    I have various functions and calcs on a spreadsheet which were all working fine last week.

    This week I have noticed that when I update a cell (which in turn updates a calc result, which in turn updates a conditional format) nothing happens, the hour glass just hangs there. When I click again on the sheet it all returns, recalculates and completes the process.

    does anyone know what is causing this?

  2. #2
    Board Regular
    Join Date
    Feb 2011
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    I don't think this is your problem but for trouble shooting purposes make sure your calculation options are set to automatic.

    To do this go to the "Formulas" tab, and un the "Calculation" ribbon click "Calculation Options" The drop down menu should have "Automatic" checked.

  3. #3
    New Member
    Join Date
    Dec 2008
    Location
    Akron, OH
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    Could be a number of things. Typically, the hourglass indicates that Excel is working/calculating. When you click somewhere during this process, it abandons calculating and allows you to edit the worksheet again. You can verify what the program is doing by checking a couple things.

    In the lower left corner of the Excel window, you can see text that says "Ready". If it also shows "Calculate", that means that Excel has more calculations to update, and is in fact not done.

    To see what is happening (kind of) while Excel is displaying an hourglass, you can open Windows Task Manager. Right-click on the Windows menu bar, and click "Task Manager". Go to the "Processes" tab. Sort top down on "CPU". If Excel pops to the top of the list, you know it is still working and calculating.

    I've had MANY spreadsheets that work quickly and efficiently until I add just one too many formulas. Then it starts hanging and taking multiple minutes to calculate. Sometimes you just have to go back through and try to simplify it.

    Hope that helps!

    -AK

  4. #4
    New Member
    Join Date
    Nov 2010
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    Quote Originally Posted by stilesbn View Post
    I don't think this is your problem but for trouble shooting purposes make sure your calculation options are set to automatic.

    To do this go to the "Formulas" tab, and un the "Calculation" ribbon click "Calculation Options" The drop down menu should have "Automatic" checked.
    Thanks for your suggestions but I need auto-calc off, also I don't use Excel 2007 (I'm on 2003 - probably should have mentioned that! )

  5. #5
    New Member
    Join Date
    Nov 2010
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    Quote Originally Posted by kurchev View Post
    Could be a number of things. Typically, the hourglass indicates that Excel is working/calculating. When you click somewhere during this process, it abandons calculating and allows you to edit the worksheet again. You can verify what the program is doing by checking a couple things.

    In the lower left corner of the Excel window, you can see text that says "Ready". If it also shows "Calculate", that means that Excel has more calculations to update, and is in fact not done.

    To see what is happening (kind of) while Excel is displaying an hourglass, you can open Windows Task Manager. Right-click on the Windows menu bar, and click "Task Manager". Go to the "Processes" tab. Sort top down on "CPU". If Excel pops to the top of the list, you know it is still working and calculating.

    I've had MANY spreadsheets that work quickly and efficiently until I add just one too many formulas. Then it starts hanging and taking multiple minutes to calculate. Sometimes you just have to go back through and try to simplify it.

    Hope that helps!

    -AK
    OK thanks, the thing is I know it is calculating as the sheet hasn't finished updating and the hourglass is there - its the fact that excel makes you click on the sheet to get it to finish calculating.

    so its not that it is taking a long time to calc - i can refresh a cell let it hang for a second then click the sheet and it will then finish - otherwise if I don't click it sits there appearing to calculate but is in fact hanging

  6. #6
    New Member
    Join Date
    Dec 2008
    Location
    Akron, OH
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    And it only says "Ready" in the lower left-hand corner? Not "Calculate" as well?

    In that case, I've never encountered that. Anyone else?

  7. #7
    New Member
    Join Date
    Nov 2010
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    typical, cant recreate it at the mo, it will happen again and will post when it happens again

  8. #8
    New Member
    Join Date
    Mar 2013
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Calculation Hangs until mouse is clicked

    Old thread, but I'm having this exact same problem on another workbook now. I've seen this in other projects. It's easy to reproduce at the moment. The workbook will appear to hang and calculate indefinitely until I click anywhere on the sheet (or press an arrow key in any direction). At that time, it generally finishes immediately and the screen is refreshed. It feels like a screen refresh issue. Would appreciate any solution, if one exists.

    Quote Originally Posted by 2bit View Post
    typical, cant recreate it at the mo, it will happen again and will post when it happens again

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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