95, 97 and 2000 Not Calculating

bocce · Mar 5th, 2002, 04:44 PM

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 · Mar 5th, 2002, 06:08 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 04:44 PM	#1
bocce New Member Join Date: Mar 2002 Posts: 1	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

Mar 5th, 2002, 06:08 PM	#2
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	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.