We have multiple reports that break on unique business unit, with the BU as the header. All the output is in the same section of the report, but when we export to Excel 2007 from 12C, it breaks each business unit into it's own tab on the spreadsheet, where 11G exporting did not.
We are trying to get the exported output to appear on one tab.
In the Pivot Table properties, under Options, there is a drop down for Insert Page Break. Apparently, breaking pages on a specific column value creates tabs in Excel for each break, and titles the tab according to the header, which is the column value.
To stop the new tabs in Excel, turn off the page break.