Archive for March, 2016

MS Project Calculation Option and ERROR

Tuesday, March 29th, 2016

Microsoft Project Calculation Option and ERROR on few fields

V: 1.0, Updated: 03/29/2016

Scenario

Microsoft Project as a scheduling application, runs different formulas behind the scene.  You may run into the following scenarios:

  1. Some of the columns (fields) in Microsoft Project will not show the updated data
  2. Some of the fields will show #ERROR instead of the data

Cause

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.

MSP2013_Calculations_01

 

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.

MSP2013_Calculations_02

 

Resolution

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.

MSP2013_Calculations_03

 

 

Summary

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:

  1. File > Options > Schedule > Calculation and set to On
  2. Hit Ctrl F9 to turn on / Off calculation option
  3. Right click on the top left cell in the view and choose Calculate Project from the menu MSP2013_Calculations_04
  4. Add Calculate Now or Calculate Project commands to the Quick Access Toolbar

 

Add Commands to the Quick Access Toolbar

  1. To add commands to the Quick Access Toolbar, right click on it on top right  and choose ‘Customize Quick Access Toolbar‘ (of go to File > Options > Quick Access ToolbarMSP2013_Calculations_05_CustomizeRibbon
  2. Choose ‘All commands‘ under ‘Choose commands from’ drop down. From the list of commands, select Calculate Now and click Add button in the middle to add it to the right side. [You can add Calculate Project command as alternate] MSP2013_Calculations_06_CustomizeRibbon
  3. You will see the commands icon in Quick Access Toolbar MSP2013_Calculations_07_CustomizeRibbon

 

Keywords

  • #ERROR in Microsoft Project
  • #ERROR in Project Calculation
  • Manually recalculate project data
  • Auto recalculate project data
  • Tasks not Scheduled as expected
  • Scheduling issue in Microsoft Project
  • Four calculation options in Microsoft Project

Create New Project from Existing in MS Project

Monday, March 21st, 2016

Creating a new project using an existing Project

[If your project was on Project Server, first save as the project on your desktop as .mpp file]

  1. Open MS Project Professional 2013 and make sure you are connected to MS Project Server PPM
  2. Go to File menu > New
  3. Under Featured tab click on ‘New from existing project’ icon

MSP2013_UseExisting_ProjectTemplates2

  1. In ‘New from Existing Project’ dialog box, navigate to the .MPP project file from your desktop and click Open
  2. Click on File > Save As > Save button
  3. In the next dialog box, enter the name of the project and click Save

MSP2013_UseExisting_ProjectTemplates3

  1. Continue to modify the project after the status bar in bottom middle says ‘Save completed successfully’

 

Creating a new project using Enterprise Templates

Only Project Server Administrators can save projects as Enterprise Templates.

  1. Open MS Project Professional 2013 and make sure you are connected to MS Project Server PPM
  2. Go to File menu > New. Then click on Enterprise tab on the right side (the view defaults to Featured)

MSP2013_UseExisting_ProjectTemplates

  1. Click on one of the relevant template
  2. Before making changes, click the File > Save option
  3. Enter the name of the project and other custom fields information
  4. Click OK
  5. Continue to modify the project after the status bar in bottom middle says ‘Save completed successfully’

Protected: Project PPM Reporting and BI

Tuesday, March 1st, 2016

This content is password protected. To view it please enter your password below: