Export To Excel error “SaveAs method of Workbook class failed” or “Open Method of Workbook Class Failed” in FDM

Applies to:
Hyperion Financial Data Quality Management – Version: 11.1.1.1.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms
When trying to export to Excel an error is returned:
“Error: SaveAs method of Workbook class failed”

Cause
Known issue noted in the FDM ReadMe documentation was not implemented or implemented correctly.

Solution
Follow the steps outlined for Excel 2003/2007 and Windows 2008 as noted in the “Known Issues” section of the FDM ReadMe.pdf

When using Windows 2008 server x64, create the following directory to enable Excel importing and exporting:
      \Windows\SysWOW64\config\systemprofile\Desktop
When using Windows 2008 server x86, create the following directory to enable Excel importing and exporting:
      \Windows\System32\config\systemprofile\Desktop


Important:
Lastly, bring up the Task Manager on all FDM Application Servers and end any hung Excel.exe processes.

Documentation is found on Oracle Technology Network (OTN) at the following URL:
http://download.oracle.com/docs/cd/E17236_01/index.htm

Advertisements
This entry was posted in Hyperion Financial Data Quality Management, Oracle EPM and tagged , , , , . Bookmark the permalink.

2 Responses to Export To Excel error “SaveAs method of Workbook class failed” or “Open Method of Workbook Class Failed” in FDM

  1. terrywloch@wp.pl says:

    thank you, u save me

  2. Paula says:

    Thank you so much!! It saved me too!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s