Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    St. Louis, Missouri, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation Hangs in Excel XP (XP 10.2614)

    I have several large Excel models that take a few minutes to calculate. We have experienced situations where the calculation step (called from a VB program) hangs. However, we are able to break the program and try the calculation step again, and sometimes after a few tries it works. This same behavior sometimes occurs even when calculating without a VB program. If we open several linked workbooks, and calculate, it will hang. But if we open just one,and get it to calculate, then open more of them, we can eventually get to the point where they are all open and calculating! These models had no problems running with Excel 2000.

    Has anyone else experienced this? I know my version is very old (pre SP1), but our IT desktop "support" department insists on controlling the distribution of software and is not planning to install SP1 until October, at which point they will still be one service pack and one year behind. I can probably "illegally" install the updates, but I'd feel better about it if this was a known issue that is fixed in SP1 or later updates. Any help would be appreciated.

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Calculation Hangs in Excel XP (XP 10.2614)

    Steve,

    Take a look at this site for more than you ever wanted to know about calculation in Excel.

    http://www.decisionmodels.com/calcsecrets.htm

    Jim Cone
    San Jose, CA

    Hyperlinks added- Mod

Posting Permissions

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