Techthinkerslabblog

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

For more information Contact us at

http://www.techthinkerslab.com

Mobile:

+91- 9663034204,8884702534/2386

+1 - 8473806550(USA).

Mail ids:

sudhakar@techthinkerslab.com

hyperionsupport@techthinkerslab.com

skype id:techthinkerslab

Thank You,

 Techthinkerslab Staff.