Home » Developer & Programmer » Reports & Discoverer » Export to Excel Fails
Export to Excel Fails [message #88353] Tue, 16 July 2002 05:08 Go to next message
edjessup
Messages: 1
Registered: July 2002
Junior Member
I am attempting to export a multi-tab workbook to Excel. Discoverer will start the export process but fails after exporting a few tabs. Has anyone else experienced this problema and do you know a solution to fixing it?

Any help would be appreciated.
Re: Export to Excel Fails [message #88429 is a reply to message #88353] Wed, 28 August 2002 12:30 Go to previous message
Mark
Messages: 284
Registered: July 1998
Senior Member
We had some similar problems exporting to Excel. They involved set-up issues mostly, but some user error. The two major learnings when exporting to Excel at the beginning of a new installation that we found were:

1) Had to change the code to recognize 65,000 lines in Excel per tab rather than 10,000 (based on Excel 95 limits).

2) Export test would be successful during a limited test. We would review the test results in the Excel file. If satisfactory, we would export the entire file. The user error was that we didn't close the Excel file before trying to export again. Discoverer has a hard time exporting to open files and usually gives up and returns an error message.

Not sure if either of these applies in your situation. They both appear to be start-up issues.
Previous Topic: Oracle Applications 11i / Discoverer joins configuration and joins definitions
Next Topic: Re: Producing oralce Reports in Excel
Goto Forum:
  


Current Time: Thu Mar 28 08:21:18 CDT 2024