Invalid sheet or chart name when exporting results to a spreadsheet in Scenario Mode



1 comment

  • Official comment

    Reason for the Error:

    Scenario results are exported to a different Worksheet than the same result in Result Mode. When exporting scenario time history results to Excel, the name of the Worksheet is “SheetName-Scenarios”, where SheetName is the name that you specify. Microsoft Excel requires that the name of any Workbook is limited to 31 characters. If your original excel Worksheet name has more than 21 characters, then the scenario export will try to add a Sheet with a name that has more than 31 characters, thus violating Microsoft's 31 character limit. 

    Change your Excel workbook name to have less than 21 characters before running your simulation in Scenario mode to avoid violating the character limit. Update the Time History elements accordingly to correspond to the new sheet name.

    Comment actions Permalink

Please sign in to leave a comment.