95, 97 and 2000 Not Calculating

[bocce]

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

 

[GeorgeB]

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.