You need to ensure that Excel is installed on the machine where Data Pump is installed to get the Excel formatting.
Additionally you need Monarch 8 and MDP 8 to get the page break formatting in Excel. That feature was only introduced in V8.
I have a model that produces a report that has different formatting including a page break between different key values. When you export with an .xmod no formatting is made what-so-ever. I used that same .xmod and saved it as a .mod and exported and it at least did the color and heading format, but still no page breaks. I have it set so it should 'Apply formatting to XLS files'. Was wondering what is up with this issue. /b[/quote]