"Automatic" Calculations

[Dave]

I'm using MSP 2003 Server. I'm created a custom field that can be used
in the PWA project center to display whether or not a project needs to
be published (i.e. has any task(s) where the Update Needed flag is set
to "yes"). To do this, I did the following:

Created a field called [Tasks Not Published] using [Enterprise Flag2].
The formula simply makes this field = [Update Needed] and then uses an
"OR" in the rollup to get any "Yes" to rollup to the project/summary
level. Created another field called [Published] using Enterprise
Project Text8 with the formula ... IIf([Tasks Not
Published],"No","Yes")).

The above works fine except for one thing. In order to get it to do
the calculation, I have to open each project and manually calculate.
The problem starts with the OR in the [Tasks Not Published] field. For
example, I move a task so that the [Update Needed] flag changes to yes
for that task. At that point, the [Tasks Not Published] field for that
tasks immediately changes to "Yes"; however, the OR is not
automatically calculated, so the "Yes" does not roll up. If I manually
calculate, the OR kicks in and the Yes rolls up.

I have the calculation options set to Automatic for All Open Projects.
So what does that mean? It doesn't really automatically calculate all
open projects? If it does, what is it "automatically calculating"? I
thought that maybe it didn't recalculate until you saved it and/or only
when the project is opened, but it doesn't work either way.

I'm having this same issue with other custom fields I've created. Any
suggestions?

Thanks.
Dave