Applies to: @RISK 5.x and Up

I have template reports defined. After a simulation, I expect the generated reports to contain fixed numbers, but instead they contain formulas.

 

Cause:

This happens when your template has filters.

Excel's copy/paste (used by @RISK) cannot paste filtered ranges correctly, so formulas appear instead of fixed values.

Workarounds:

1. Remove the filter, or
2. After the report is created, select the data, Ctrl+C
3. Edit » Paste Special » Values into a new sheet.
4. You can also try using Excel’s “copy to another location” in the Advanced Filter options.

 

Related Article:

Creating and Using Report Templates