This content has been marked as final. Show 3 replies
Firstly, it could be macros in the Excel file, so try setting the preference ExcelExportWithMacros to 0. If is also worth exporting the files as csv or html and then opening with Excel, this often gives a better outcome.
If those options don't work then try using VBScript to open the export file in Excel 2003 and save in the Excel 2003 version.
I agree that it's the macros that do all the formatting. You could edit the following line in your pref.txt with the following:
ExcelExportWithMacros = 1 #If this is made 0, the exported excel file won't have any macros and hence no formatting also..
Of course this means that no one will get formatting when reports are exported to Excel
Edited by: user12123800 on Feb 24, 2010 5:34 AM
By the way, I'd be interested in see how you set up the email distribution process. I am exploring using BI Publisher to run the Discoverer Reports and using its scheduler to distribute. Need to run some patches on the Discoverer server first though.