Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel Not Opening the 1st Sheet

530085Oct 28 2008 — edited Jul 19 2012
When 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!
This post has been answered by Tamir Lazover on Oct 29 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2012
Added on Oct 28 2008
18 comments
3,179 views