Some of our staff get an error when trying to export report data to Microsoft Excel from our site.  How can we export the data? 

Environment:

Workstation, Analytics

Resolution:

Is it safe to open the file when the operating system presents a warning about the file extension?

Staff may receive a message or error when exporting report data to Excel. The specific action to take depends on the message that displays.

Note:  When exporting report data to Excel, you must be running a supported version of Excel. Please see the system requirements for your current version of Oracle B2C Service:  System requirements to run Oracle B2C Service products.

Messaging displayed to agents:

The File you are trying to open, 'Scheduled Excel report.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?:

When a report is scheduled in Excel format, it is actually created in a different format, and then renamed with an Excel extension so that it will automatically open in Excel.  Do not be alarmed by this message in relation to Oracle B2C Service report exports.

Unable to launch application for this file: 
If you get this message, ensure there is an application associated with this file extension.

Old Format or Invalid Type Library error:
If you run an English version of Excel, but the regional settings for the computer are configured for a non-English language, you will get the error below:

Description: Old Format or Invalid Type Library
Error: 0x80028018

For more information on this issue and how to resolve it, refer to Microsoft Knowledge base article 320369.