Home → Troubleshooting → @RISK for Excel: Other Issues → 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