E-QR: PSQuery Download to Excel On WebSphere Gets (a) Security Warning and (b) Error "Microsoft Office Excel cannot access the file"
Last updated on MAY 04, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
Checked for Relevance on 25-JUL-2013.
When trying to download query to Excel users are getting a File Download - Security Warning pop-up message followed by an error of access to the file. Running query to HTML will return the correct set of results.
This issue only happens in Internet Explorer browser, no problems with Mozilla Firefox browser.
Also it has been found as WebSphere Application Server specific.
1. Log in into PIA.
2. Navigate to Reporting Tools > Query > Query Manager.
3. Search for a query.
4. Select "Excel" link to download Query to Excel.
1. First appears a Security Warning popup message box with text like:
Type:Microsoft Office Excel 97-2003 Worksheet
2. Followed by the below error:
There are several possible reasons:
The file name or path does not exist.
The file is being used by another program.
The workbook you are trying to save has the same name as a currently open workbook."
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms