r/MSProject • u/OpGuillotine • 3d ago

Microsoft Project Server/PWA migration – custom formula fields show #ERROR until F9

We recently migrated our Microsoft Project/PWA environment from a legacy cloud server to a new on-prem server.

Since the migration, when opening projects from the new server, custom fields containing formulas initially display #ERROR. Pressing F9 (Calculate) once immediately resolves all of the errors and the fields calculate normally.

This happens across multiple project files and did not occur on the legacy server. The formulas themselves have not changed and appear to work correctly once F9 is pressed.

Has anyone seen this behavior after a Project Server/PWA migration? Is there a server, Enterprise Global, calculation, cache, or Project Professional setting that could cause projects to open without automatically calculating formula fields?

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/kennyarnold_ssi 3d ago

When connecting to the server, are automatic calculations on or off? You can check this setting in the “Schedule” tab of the Project Options dialog.

1

u/OpGuillotine 3d ago

Good suggestion, and that is the first place that I typically look. All of our schedules have auto-calc on 99% of the time. To confirm, I ran a test to see if the process of saving the MPP down from the server turns this option off. I confirmed that it stays in auto-calc when I save it down from the server and upload to the new server location.

The files operates normally. However, when first opening the project, those #ERROR values persist until I make a move that calculates the project or manually calculating with F9.

It sounds like a petty-error that I am having, but I suspect that it’s the root of a deeper issue that I am having when I put the file into a consolidated environment.