Home →
Troubleshooting →
@RISK for Excel: Simulation →
**Template Report Contains Formulas in Place of Numbers**

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

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

This situation can arise when you have filters defined in your template. The problem comes from a limitation of Excel's copy/paste, which @RISK uses: When @RISK tries to copy/paste a sheet that contains filters, Excel raises an error to the effect that the source and target aren't the same size.

Here are some possible workarounds:

- If you don't need the filter, remove it.
- Let the report be created as it is now. Then, select the actual data area of the report (not the template), press Ctrl+C for Copy, then Edit » Paste Special » Values into an empty sheet. Excel won't paste the filtered-out rows.
- You might try automating the Advanced selection in Excel filters by using its option, "copy to another location".

Last edited: 2015-08-07

This page was: Helpful |
Not Helpful