Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculations Not Updated (Excel2000 sr1)

    Coworker created a spreadsheet using basic formulas (specifically, multiplication). However, as she adds numbers to the cells referenced in the formulas, the formula results are not updated. If we press F9 all formulas in the worksheet are updated. Why are the formulas not updated on the fly?

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculations Not Updated (Excel2000 sr1)

    Tools | Options, Calculation tab, set the Calculation Automatic option button. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations Not Updated (Excel2000 sr1)

    Thank you!

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations Not Updated (Excel2000 sr1)

    Note that the calculation modes as set under tools, options, calculation are always determined by the *first* workbook that is loaded in Excel.

    So even though the settings get saved with the workbook, the settings in Excel will always reflect either the ones of the first loaded workbook *or* the ones you last invoked by changing things in tools, options manually.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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