Excel Not Opening the 1st Sheet
530085Oct 28 2008 — edited Jul 19 2012When exporting a Discoverer file to Excel, I want Excel to open the Excel file automatically after export. During the export process there is an option at the end to open the 1st exported sheet. I check this, but it doesn't automatically open. I see in the help area, it tells me to do the following:
Open the first exported sheet
Use this check box to open the first file in the file list when you close the Export Wizard. For example, if the first file is a HTML file, your Web browser will display the HTML file. Note: If you export to Microsoft Excel format and Microsoft Excel does not open the first exported sheet, check that you have the correct security level for macros. For example, in Microsoft Excel 2000, choose Tools | Macro| Security and set the security level to Medium or Low.
So I went into Excel and set my macro security setting to Low and saved that Excel document. I exited Discoverer and logged back in. Tried exporting again, but it still won't automatically open. Any ideas?
Thanks!