Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate formulas (Excel 97)

    How do I make the worksheets automatically calculate the formulas when values are assigned? I have had to do it individually for each cell and it takes a lot of time. Also, the cell values do not automatically recalculate.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Calculate formulas (Excel 97)

    Your Calculation mode must be set to manual. If this is so pressing F9 should recalculate the whole worksheet, However a better solution would be to set the Calculation mode to Automatic. To do this go to Tools, Options and select the Calculation Tab. tick the Automatic option and see if it cures your problem.

    If you are working with large complicated worksheets it can be useful to set the mode to manual, but in general Automatic is the best choice.

    Andrew C

Posting Permissions

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