HomeTroubleshooting@RISK for Excel: Other Issues"The workbook ... has @RISK simulation settings stored in it. ...

8.40. "The workbook ... has @RISK simulation settings stored in it. ...

Applies to: @RISK 5.x–7.x

When I open certain Excel files, I get the message

The workbook workbookname has @RISK simulation settings stored in it. Do you want to change the current @RISK settings to match those stored in this workbook?

What does this mean? How can I avoid the message?

The message is telling you that the workbook you're about to open has simulation settings inconsistent with the currently open workbook. (If you have only a blank workbook open, then the settings in the new workbook are inconsistent with your simulation defaults in Application Settings.) @RISK wants you to decide which set of settings should be in effect for both workbooks, since all open workbooks must have the same settings.

In general, you don't want to have multiple workbooks open in @RISK unless they are all needed for the same simulation. Therefore, the best practice is usually to close workbook A before you open workbook B. If you have workbook A open with @RISK settings, and you're opening workbook B with different @RISK settings, you probably want to answer Yes, then close workbook A without saving it. If you have made changes in workbook A that you don't want to lose, say No and close workbook B without saving (so that its simulation settings won't change); then save and close workbook A and reopen workbook B.

You may be able to eliminate or at least reduce these warnings by adjusting your Application Settings, if you always make the same choices for all models. That is the simplest and safest approach. For more information, please see Avoiding "Do you want to change the current @RISK settings to match those stored?"

Last edited: 2015-10-15

This page was: Helpful | Not Helpful