HomeTroubleshooting@RISK with ProjectsProject Not Linked in @RISK 6.x/7.x

6.3. Project Not Linked in @RISK 6.x/7.x

Applies to: @RISK 6.x/7.x, Professional and Industrial Editions

I moved or renamed my Excel or Project file. Now, when I open it in @RISK doesn't link to the .MPP file automatically.  I tried to restore the link in Project Settings, but I can't open that dialog because I don't have a project open.  What can I do?

You can re-establish the link by creating a name RISKMPPPath in the Excel workbook.

In Excel 2007 or newer:

  1. Click Formulas » Name Manager.
  2. Look for RiskMPPPath (three consecutive P's).  If it's there, highlight it and click Edit.  If it's not there, click New and create it.
  3. In Refers to, enter the full path and file name of the MPP file, such as
    ="C:\Users\Sanjay\Desktop\Simple Risk Register.mpp"
  4. Click OK and then Close.
  5. Save, close, and reopen the workbook.  (You don't need to shut down Excel.)

If the RiskMPPPath name exists but the Edit button is grayed out, the current sheet may be protected. Right-click on the tab for this sheet and select Unprotect Sheet. If Unprotect Sheet doesn't appear, the sheet is not protected but the workbook may be. Verify that it is not read only and not protected from editing.

In Excel 2003:

  1. Click Insert » Name » Define.
  2. Look for RiskMPPPath (three consecutive P's).  If it's there, highlight it.  If it's not there, click Add and create it.
  3. In Refers to, enter the full path and file name of the MPP file, such as
    ="C:\Users\Sanjay\Desktop\Simple Risk Register.mpp"
  4. Click OK and then Close.
  5. Save, close, and reopen the workbook.  (You don't need to shut down Excel.)

If the RiskMPPPath name exists but Excel won't let you edit the reference, the current sheet may be protected. Click Tools » Protection » Unprotect Sheet. If Unprotect Sheet doesn't appear, the sheet is not protected but the workbook may be. Verify that it is not read only and not protected from editing.

Last edited: 2015-10-15

This page was: Helpful | Not Helpful