HomeTroubleshooting@RISK for Excel: Other IssuesDetailed Statistics Report in Excel is Pivoted

8.22. Detailed Statistics Report in Excel is Pivoted

Applies to: @RISK 5 and newer

I opened the Detailed Statistics window after my simulation, and it looked normal, with one column for each output or input. But when I clicked the icon at the bottom for "Report in Excel", the report was transposed, with one row per output or input and each statistic in a column.

This is by design. There is an internal limit of 256 columns for this report in Excel, even Excel 2007 and later, so if you have more than that many outputs and inputs @RISK pivots (transposes) the report.

If you have under 256 outputs and you don't actually need inputs collected — if you're not planning to do sensitivity analysis — then you can get around this. Open Simulation Settings, and on the Sampling tab change "Collect Distribution Samples" to None.

Last edited: 2015-03-24

This page was: Helpful | Not Helpful