Issue when exporting to Excel: multiple worksheet tabs "grouped"
When I export WebI reports that are designed to have multiple report tabs to Excel, all of the worksheet tabs are selected and active, and the report title has [Group] appended to it.
MS Excel's Help states, "Tip When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu."
Is there any way for me to ensure in the WebI report that upon export to Excel, the first worksheet tab is the only one that is selected and active? My users view it as a bug and do not want to do the extra step of clicking on the worksheet tabs once the report is opened in Excel.