Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating (Excel 2000)

    We have a file of 53 tabs. It links to one other file. There are approximately 70,000 formulas (all formulas are exactly the same). It takes about 40 minutes to calc the file. It also takes forever to save the file. The PC has 256 RAM, Win 2000, the CPU is 1.1 Ghz. The files are saved on the network. Any ideas how to speed this up? Would more memory do it? What is out there in the world for calculations to run faster?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    Check to see if there is antivirus software running on the server that might be interfering.
    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Calculating (Excel 2000)

    What kind of formulas, and what do they do?
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    <P ID="edit" class=small>Edited by WebGenii on 05-Mar-02 22:03.</P>Here is a site with lots of details about how Excel prioritizes calculations, along with advice about how to minimize bottlenecks and avoid certain pitfalls.

    They also sell a product that measures calculation speed for various blocks, helps you identify bottlenecks and gives advice on how to clear up the bottlenecks if possible. I haven't used the product, but it looks interesting.

    http://www.decisionmodels.com

  5. #5
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    Is there a difference if you save it on your hard drive? What size is the file?

  6. #6
    New Lounger
    Join Date
    Mar 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    Yes, we saved it on both files on the hard drive and it cuts the time to calc to 7 min.

  7. #7
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    So either you've got a bad network or as Legare said, you may have antivirus software getting in the way. I always tend to work off the hard drive and then upload to the network. I know this isn't always possible for access reasons and is not desirable for backup reasons either but it works for me in the majority of cases. Now you just have to decide whether 7 minutes is acceptable....

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Calculating (Excel 2000)

    Hi,
    Can you give examples of the sorts of formulae you're using? Are they long and complicated or are there just a lot of them?
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating (Excel 2000)

    That is a pretty good indication that the problem is something like I suggested in my previous message, like an anti-virus software running on the server that is interfering with Excel. Depending on which anti-virus it is, it may have parameters that can be set to aleviate the problem.
    Legare Coleman

Posting Permissions

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