Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: 95, 97 and 2000 Not Calculating

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is an old problem from a prior version a few years back that I thought was resolved. I am running NT, and use a lot of custom functions to save space and for ease of updating. I am seeing 2 very strange calc problems:
    1. The "calc" indicator is clear, indicating that it is fully calced, but it is not (when I re-enter the formula, it changes value). This occurs in all versions in manual or auto calc mode.
    2. Sometimes, upon calcing, the "calc" indicator stays on even though I know it is calced.

    Please help!

    Bocce

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is a well known "bug" in Excel. Microsoft knows about it and says they're working to fix it. It usually occurs when your Workbook gets large with many links.
    Try Ctl Alt F9. If that doesn't work save it to another location. That will force a recalc.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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