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

 

Error

"Error linking the opened workbook with the associated .MPP file" 

Causes and Solutions

There are several possible causes of this error.

1. There may be a problem with the Excel workbook or the MPP file.
   1. Close all open instances of Excel, 
   2. Reopen @RISK.
   3. Click Help » Example Spreadsheets.
   4. In the Table of Contents, click Simulation with Microsoft Project, and then select one of the examples.
   5. If the example triggers the same error, it's likely a problem in the installation of @RISK, Office or Project.
      1. Re-register the Visual Basic runtime:
         1. See Visual Basic 6 Runtime for details.
      2. Close Excel and Project
      3. Double-click on the MPP file.
         1. If it doesn't open, repair Microsoft Project to re-establish the connection with MPP files.
         2. If it opens, make sure Project is the default application for opening MPP files:
            1. See Microsoft's Change Default Apps in Windows  OR
            2. How-to Geek's How to Set Your Default Apps in Windows 10
2. If you've done all of the above without success, please run:
   1.  the DTS diagnostics for software version 7.x or for version 6.x
   2. Send the file to Tech Support by logging into the Lumivero Community Home Page and clicking on the Submit a Case button to fill out a form for assistance from the Support Team.
      1. Be sure to provide your serial number and mention the nature of the difficulty you're having on the form.
3. If @RISK opens Project and the Correlations.mpp file, (and you can perform a successful simulation), this indicates the installations of @RISK and Office are ok but there may be a problem with the data files.
   1. Re-import the MPP file, and create a couple of inputs and outputs. If you can now simulate, the MPP file is good but the old Excel file became corrupted.
      1. Save the new Excel file and re-create the @RISK modeling features (or manually copy them from the corrupted Excel file).
         1. If you choose the latter, copy parts of sheets, not whole sheets.
      2. Open the workbook without @RISK running and copy the columns that have distributions into a new blank workbook.
      3. Reimport the associated MPP, and copy those columns of distributions into the reimported workbook.
4. If you still can't simulate after re-importing the file, the MPP file is corrupt.
   1. Open a new blank project and copy the contents of your corrupt project to the new one.
   2. Close Excel and Project, reopen @RISK and try importing the new file.

 

NOTE: If the problem was that your MPP file or Excel file was corrupt, you may want to uninstall and reinstall Office and Project to reduce the likelihood of a recurrence. We have seen this work successfully.