Custom Fields

[Jim Stoaks]

The configuration is Project Pro 2003 that is saving to Project Server 2003.

I have created a formula in the Number1 custom field. I have saved the
field and also used organizer to move it to the Global template and out to
other projects.

When I first open up the project the field lists #error. When I open up the
formula in the custom field it lists the correct formula and when I click OK
it executes that formula and the correct value is displayed instead of #error.

How do I get the project to automatically load and execute the formula?

Thanks,
--Jim

 

[Brian K - Project MVP]

The configuration is Project Pro 2003 that is saving to Project Server
2003.

I have created a formula in the Number1 custom field. I have saved the
field and also used organizer to move it to the Global template and out to
other projects.

When I first open up the project the field lists #error. When I open up
the
formula in the custom field it lists the correct formula and when I click
OK
it executes that formula and the correct value is displayed instead of
#error.

How do I get the project to automatically load and execute the formula?

Thanks,
--Jim

Some action needs to take place that causes a calculation of the project.

the following code placed into the project should work. It will cause
project t calculate the active project as soon as it is opened.

Private Sub Project_Open(ByVal pj As Project)
Application.CalculateProject
End Sub

 

[Vadim Bogdanov]

Hi Jim,

please check that automatic calculation is turned on
(Tools-Options-Calculation tab).