HomeTroubleshooting@RISK with Projects"An error has occurred linking the selected project ..."

6.16. "An error has occurred linking the selected project ..."

Applies to: @RISK 6.1, Professional and Industrial Editions

I have an Excel workbook that was linked to a project in @RISK. When I try to open the project, I get this error message:

An error has occurred linking the selected project to the opened workbook in Excel. The newly opened workbook will be closed.

I click OK, and the workbook does close.  How can I get access to my project and workbook?

This unfortunately was a program error that affected certain projects when opened in @RISK 6.1.

It was repaired in @RISK 6.2.0.  If you have a current maintenance contract, please visit our upgrades page, or contact your Palisade sales office to request an upgrade to the latest version.

If you don't have a current maintenance contract, or your company policy will not let you install the upgrade, follow this procedure:

  1. Re-import the project and save the resulting workbook under a new name.

  2. Close @RISK.

  3. Open Excel (not @RISK) and copy your input distributions and your outputs from the old workbook to the new one.  The formulas that involve @RISK functions will display #NAME or other error codes, but you can still copy/paste them in Excel.

Last edited: 2015-10-15

This page was: Helpful | Not Helpful