FDM Export to Excel Process Returns Error "File Could Not Be Opened"
Posted by Priya Doyle on 08 February 2011 04:05 PM
Applies to:Hyperion Financial Data Quality Management - Version: 220.127.116.11.00 to 18.104.22.168.00 - Release: 9.3 to 11.1
Information in this document applies to any platform.
Clicking the "Export to Excel" icon on the import screen returns the following error message:
The following information is written to the user error log:
This error message indicates that either:
a) Smart View is installed on the FDM application server within Excel which will cause this issue.
b) The Essbase Spreadsheet Add-In is registered within Excel on the FDM application server.
c) Also, if any other Excel Add Ins (possibly non-Hyperion) is installed.
Discovered this issue is being caused due to the Performance Point Excel Add In being installed within Excel on the FDM application server.
A) Uninstall the Performance Point Excel Add In within Excel on the FDM application server
B) Re-run the "Export to Excel" process from the import screen in FDM.