I am running Windows 2000 5.00.2195 with Service Pack 4 and Excel
2000 9.0.6926 SP3.

It appears that something is wrong with automatic calculation and
Application.Calculate. I have the following formula in cell C433 of
several of my sheets:

=RevisedQ(TIS, SStat, DFact, ForceC, Weights, MATCH(ForceT, TNames,
0))

RevisedQ is a VBA macro defined in a module attached to the workbook.
The arguments are Excel named variables, either local to the
particular sheet or global. The prototype for RevisedQ is

Public Function RevisedQ(TIS As Range, SStat As Range, DFact As
Range, ForceC As String, Weights As Range, TIndex As Integer) As
Double

Here is the problem: The value in C433 changes when I change an input
parameter (via a drop down listbox on one of the sheets) and
automatic calculation is turned on (or when I change the input
parameter and execute Application.Calculate via a command button
click). However, the value it becomes is an incorrect value. To get
the correct value I must navigate to each sheet, click on cell C433,
then click in the address bar where the formula is displayed and
press return. This indicates that the workbook does not initially
calculate correctly.