Palisade Knowledge Base

HomeTroubleshooting@RISK for Excel: Other Issues"The data in the workbook ... is invalid"

8.46. "The data in the workbook ... is invalid"

Applies to:
@RISK 5.x for Excel

Problem:
When I open my workbook in @RISK, I get the message

"The data in the workbook workbookname is invalid."

Response:
Most likely, your data from a previous simulation, stored in this workbook, are corrupt. To clear the error, please follow these steps:

  1. In @RISK's Utilities menu, select Clear @RISK Data.
  2. The Clear @RISK Data dialog box appears. Select "Simulation Results" and clear any marks that appear for the other options. Click OK and answer the confirming prompt.
  3. Save your workbook.

Did you actually intend to store simulation results in the workbook? There are certainly valid reasons to do that, but the tradeoff is that your workbook grows larger and that can slow down your simulations. For other ways to store your simulation results, please see Excel Files with @RISK Grow Too Large.

last edited: 2010-05-20

This page was: Helpful | Not Helpful