Microsoft Project Calculation Option and ERROR on few fields
V: 1.0, Updated: 03/29/2016
Microsoft Project as a scheduling application, runs different formulas behind the scene. You may run into the following scenarios:
Microsoft Project has a calculation option that is set to On. Go to File > Options > Schedule > Scroll down to Calculation section on right. You will find On and Off options there. It defaults to On. You can hit Ctrl F9 to turn on or Off the calculation setting in Microsoft Project. Notice the bottom left of status bar and you will see the calculation change messages.
The setting says ‘Calculate project after each edit‘. In case no edits are made, the project will not calculate data! In situations, you will see #ERROR message in cells for few fields. For example create a Date field and use formula Now() to populate current date in that field.
Even with Calculation option set On, if you see the #ERROR or don’t see the correct data, hit the F9 key. It will force the calculation and will update the data in Microsoft Project.
There are four ways to let Microsoft Project perform the calculations. We discussed few options above. Below are four calculation options in Microsoft Project and one of which can be used:
Add Commands to the Quick Access Toolbar