Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Calculation speed (2000 SR2)

    Hi,

    I have a large spreadsheet (28Mb) which takes around 45 seconds to recalculate. I've pruned it as much as I can but it's still far to slow so I'm going to have to throw some hardware at it.

    Is it worth going for the new dual core intel chips or should I just get the fastest single core one I can afford?

    Thanks,
    Jim MacLeod
    Shetland Isles

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calculation speed (2000 SR2)

    I won't answer the hardware question since I have no expertise in the area, but I will suggest something concering software question.

    I have no idea what you have in the workbook that is so calculation intensive (I suspect array formulas, or a large number of IFs), but it seems to me a reevaluation of the workbook and the calcs should be examined to eliminate or modify the formulas to be more efficient.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation speed (2000 SR2)

    In addition to Steve's reply, see Excel Pages - Optimising Speed for some tips and suggestions.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Calculation speed (2000 SR2)

    Hi,

    I've done as much formula modification as I can & got the recalc speed down from around 3 minutes to 45 sec. Splitting the spreadsheet is not an option, hardware is the best option left for me.

    Thanks,
    Jim

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation speed (2000 SR2)

    I'm afraid I am not a hardware expert. I don't know if Excel will benefit from a dual-core processor or not.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Calculation speed (2000 SR2)

    There are other alternatives other than formula modification. If the problem is many array formulas, then you may benefit from using a macro and have it calculate based on some event. Multiple arrays are very inefficient since they each may do hundreds, even thousands of calculations, and they repeat calculations that other formulas do. Each change in some parts of the workbook could require millions of calculations to be performed.

    Also pivot table options can be changed to modify the recalc time if that is an issue.

    Steve

Posting Permissions

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