Calculation
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Calculation

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi guys,

    Does anyone know how I can limit the calculation of a workbook to a single worksheet?

    The problem is, I have quite a large workbook and only one part of one worksheet, which is a reference to time, changes each time the sheet is opened. Still it takes a good 45 seconds to finish the calculation, which becomes very frustrating.

    No probs as far as speed or memory of computer goes. Both are more than sufficient.

    Any suggestions?

    Thankyou in advance

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My apologies.

    I just looked a few pages back and saw a very familiar question. Should have looked back first.

    Sorry guys.

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Tuberockin


    You may or may not take my advise, but i advise strongly against putting any spreadsheet into manual calculation mode as it's thwart with potetioal errors!

    Any spreasheet that requires being run in manual is most likely be designed incorrectly.

    Consider replacing any array formuals (the worst culprit) with the Database function, and/or Pivot Tables. Restrict the use of any Custom Functions (UDF's). Restrict the range that any formulas reference to their needed range only. Dynamic named ranges are ideal for this: http://www.ozgrid.com/Excel/DynamicRanges.htm If you have many volatile funnctions (eg TODAY(), NOW() etc) consider placing them in one cell and referencing that cell as needed.


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
  •  

 

 
DMCA.com