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

4.28. 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