I am experiencing strange behavior in Ms Project Professional. It is related to certain custom task fields. When I open a project, the fields show #ERROR (error). After making a minor change to the project, such as displaying an additional field and publishing, the error disappears. This behavior would not be a problem if, after publishing the first time, the error disappeared permanently. Unfortunately, the error persists. That is, I close the file, open it again and again the fields show an error, which only disappears (temporarily) after making a small change and publishing but reappears every time the file is opened. I tend to think it’s related to a formulation that depends on two other columns with rollup. Due to the calculations I have to do I can’t find an alternative solution. Has anyone seen this behavior before? Do you have a good explanation? any alternative solution?

​I am experiencing strange behavior in Ms Project Professional. It is related to certain custom task fields. When I open a project, the fields show #ERROR (error). After making a minor change to the project, such as displaying an additional field and publishing, the error disappears. This behavior would not be a problem if, after publishing the first time, the error disappeared permanently. Unfortunately, the error persists. That is, I close the file, open it again and again the fields show an error, which only disappears (temporarily) after making a small change and publishing but reappears every time the file is opened. I tend to think it’s related to a formulation that depends on two other columns with rollup. Due to the calculations I have to do I can’t find an alternative solution. Has anyone seen this behavior before? Do you have a good explanation? any alternative solution?  Read More

​