Home → Troubleshooting → @RISK with Projects → "Error linking the opened workbook with the associated .MPP file." (6.0/6.1)
Applies to: @RISK 6.0.0, 6.0.1, 6.1.0, Professional and Industrial Editions
When I open my .XLSX file in @RISK 6, I get the error message:
Error linking the opened workbook with the associated .MPP file. Check that the file can be properly opened in Microsoft Project.
What is wrong?
There is a conflict between the name of one of your fits and an internal name in @RISK. To remove the conflict, please follow this procedure:
Launch @RISK and then open your .xlsx file. When "Error linking the opened workbook..." appears, click OK to dismiss it.
On the @RISK tab of the Excel ribbon, click Distribution Fitting » Fit Manager. Delete the fits shown.
Press Alt-F11 to open the Visual Basic Editor. If the code window doesn't open automatically, press F7.
The fit names are invisible, so you're going to flip all names between visible and invisible, delete the now-visible fit names, and then flip all names back to their original visibility. To begin, paste the following macro code into the code window:
Sub SwitchNamesVisibility( )
Dim n as Name
For Each n In ActiveWorkbook.Names
n.Visible = Not n.Visible
Next n
MsgBox ActiveWorkbook.Names.Count & " name(s) processed."
End Sub
Run the macro.
Click back into your Excel sheet and press Ctrl-F3. Look for the Fit names and delete them. (You may need to unprotect the Tasks spreadsheet first.)
Back in Visual Basic Editor, run SwitchNamesVisibility again, to put all the remaining macro names back as they were.
Delete the macro, if you wish.
Save the workbook and close Excel. When you reopen the workbook in @RISK, everything should be fine.
This problem was fixed in 6.1.1. To avoid this problem in the future, upgrade to the current version if possible; see Upgrading Palisade Software. If you cannot upgrade, assign names not beginning with RPJ to your fits.
Last edited: 2013-10-17