Palisade Knowledge Base

HomeTroubleshooting@RISK for Excel: SimulationTemplate 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:

Last edited: 2015-08-07

This page was: Helpful | Not Helpful