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

    Auto Calculations (any)

    Hi. What would suddenly cause my formulas to stop calculating automatically whenever I change data somewhere else in my workbook? The auto calucation is checked under Tools and Options. I am working in a rather large workbook where many pages depend on the data of others. Also, there are no circular references. Please help. Thanks.

    -tmg9671

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

    Re: Auto Calculations (any)

    I'm afraid that's hard to say without seeing the workbook. Do calculations work correctly in other workbooks?

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

    Re: Auto Calculations (any)

    Yes, they do work elsewhere. There is just on formula that will not automatically calculate. I have to go into the cell and hit enter to refresh the formula, then it will calculate.

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

    Re: Auto Calculations (any)

    I assume that your workbook is too large to be attached, even zipped. Can you provide more info, for example the formula that causes problems?

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

    Re: Auto Calculations (any)

    It's actually a VERY large document. It seems to be working okay for now. Perhaps my system is just a little slow on the calculations. Thank you for your time.

Posting Permissions

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