Palisade Knowledge Base

HomeTroubleshootingAll Products: Startup"/R .xlsx could not be found."

2.20. "/R .xlsx could not be found."

Applies to: @RISK 6.1.1 (fixed in 6.1.2)

When I launch @RISK, I get the message

/R .xlsx could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.

or a similar message involving "C:\Program" or "ANALYS32" or some other file name or path.

Unfortunately, there was a problem in @RISK 6.1.1. When simulating with multiple CPUs, it may sometimes corrupt Excel's list of add-ins. Then the next time you open Excel, you get messages like the above. Palisade apologizes for this problem.

This error was fixed in @RISK 6.1.2, released 2013-04-16. You will want to upgrade to the current release, if you are eligible.

To clear the error:

  1. Open Excel, if it is not already open.

  2. In Excel 2010 or later, click File » Options » Add-Ins. At the bottom of the right-hand panel, select Excel Add-Ins and click Go.

    In Excel 2007, click the round Office button and then Excel Options » Add-Ins. At the bottom of the right-hand panel, select Excel Add-Ins and click Go.

    In Excel 2003, click Tools » Add-Ins.

  3. Remove the check mark from @RISK, if there is one. Remove the check marks from Excel's own add-ins, including Analysis Toolpak, Analysis Toolpak VBA, Euro Currency Tools, HTML Assistant, and Solver. If you have any third-party add-ins checked, you do not need to remove those check marks.

  4. Click OK. You may see a message telling you that an add-in cannot be located and asking permission to remove it from the list; click Yes.

  5. Close Excel.

Many people have some Excel add-ins checked although they don't actually use them. If you don't need Analysis Toolpak or the other Excel add-ins, you can ignore the rest of this article.

But if you need one or more of Excel's own add-ins, before you re-enable them you should upgrade to the current release if you are eligible to upgrade. Otherwise, to prevent a recurrence in @RISK 6.1.1:

  1. Launch Excel (not @RISK).

  2. In Excel 2010 or later, click File » Options » Add-Ins. At the bottom of the right-hand panel, select Excel Add-Ins and click Go.

    In Excel 2007, click the round Office button and then Excel Options » Add-Ins. At the bottom of the right-hand panel, select Excel Add-Ins and click Go.

    In Excel 2003, click Tools » Add-Ins.

  3. Re-enable the Excel add-ins that you need.

  4. Close Excel. Important: Complete the following steps before you run @RISK 6.1.1 again.

  5. Click Start » Run, enter the command REGEDIT and click OK.

  6. Navigate to the key HKEY_CURRENT_USER\Software\Microsoft\Office and double-click the word Office.

  7. Double-click the subkey for your version of Office: 15.0 for Office 2013, 14.0 for Office 2010, 12.0 for Office 2007, or 11.0 for Office 2003.

  8. Under that subkey, double-click Excel and then single-click Options.

  9. In the right-hand panel, you will see an entry OPEN and possibly some additional entries OPEN1, OPEN2, and so on. Look at the ones where the string in the last column begins with /R.

    For each of those, double-click the word OPEN (OPEN1, OPEN2, etc.) in the first column. In the edit window, remove the leading /R and space, then click OK. (You need to double-click the word in the first column, not the text in the third column.)

  10. Close the Registry Editor by clicking the X in the upper right corner.

Last edited: 2017-02-17

This page was: Helpful | Not Helpful