Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Workbook not auto calculating (2002)

    I have a workbook that contains about 80 individual sheets, most of which are linked to each other. Whenever I change a value in a cell, the other sheets that read that cell do not change unless I double-click the cell (or hit F2) as if I were modifying the formula. After I hit enter, the cell values then change. Why won't these cells auto-calculate? (The auto-calculate option is checked under Tools>Options.) Are there too many pages or is it just an fluke? Thanks.

    -Troy

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

    Re: Workbook not auto calculating (2002)

    Perhaps Excel is low on resources and turns off automatic calculation. You could test this by creating a copy of the workbook and removing half of the worksheets. Save the copy, then quit and restart Excel. Does the problem persist?

    Also: what kind of formulas do you have? User-defined functions do not always update automatically.

  3. #3
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Workbook not auto calculating (2002)

    I will try the test, but the problem is sporadic, so the testing may not be conclusive. This may lean toward the low resources explanation. The formulas I use are Excel formulas (SUMIF, LOOKUP) or simply one cell reading the value of a cell on another sheet. Is there a way to boost Excel's resources? Thanks.

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

    Re: Workbook not auto calculating (2002)

    You may find something useful on the DecisionModels site: Excel Pages - Optimising Speed.

  5. #5
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Workbook not auto calculating (2002)

    Very helpful! Thank you!

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Workbook not auto calculating (2002)

    Just another thought..

    I believe Excel2002 allows you to set the calc mode for each sheet separately as a sheet property.
    The property is EnableCalculation and can be set to True or False

    zeddy

Posting Permissions

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