Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    409
    Thanks
    1
    Thanked 0 Times in 0 Posts

    calculate on toolbar (2002)

    When I load certain spreadsheets, the word "calculate" appears to the right of "Ready" in the bottom toolbar. Tools/Options/Calculation shows calculation to be automatic. The word remains until I exit Excel, for all open spreadsheets, even those that did not have the term present before the triggering spreadsheet was opened. The term also remains even if all spreadsheets have been closed. Any ideas on what it means? I search the posts, but couldn't find a reference, so if it's there, I apologize.
    Thanks.

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

    Re: calculate on toolbar (2002)

    See "CALCULATE" in Status Bar. Does any of these apply to your workbooks? (The "bottom toolbar" is called the status bar)

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    409
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: calculate on toolbar (2002)

    The cause was too many VLOOKUP's. It appears that the calculations were correct, even if they were excessive <g>. Thanks for the information update on excel calculations..

Posting Permissions

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