HomeTroubleshooting@RISK for Excel: Simulation"Open method of Workbooks class failed"

4.39. "Open method of Workbooks class failed"

Applies to:
@RISK 5.x under Excel 2007

Problem:
I have multiple CPUs enabled. When I try to run a simulation, the @RISK Performance Monitor crashes with the message "Open method of Workbooks class failed". What is wrong?

Response:
Sometimes there are problems with the XML format introduced in Microsoft Excel 2007. First, make sure you are up to date on your Microsoft Office service packs. (As of this writing, SP3 is the latest for Office 2007.)

If you still have trouble, try clicking the Office button, then Save As and select Excel Binary Format (.xlsb). Then close Excel, reopen @RISK, and open the binary file.

last edited: 2012-11-12

This page was: Helpful | Not Helpful