Epma Utility To Generate .Ads File Give Error: "Compile error in hidden module: ImportsWorkbook" in Microsoft Excel 2010 [ID 1297682.1] To Bottom

---

 

Applies to:

Hyperion Planning - Version 11.1.1.3.00 and later
Information in this document applies to any platform.
*** Checked for Relevance 20-Sep-2012 ***

Symptoms

The following error is received in Excel when opening a workbook that has been generated with the EPMA file generator in Excel 2010:

"Compile error in hidden module: ImportsWorkbook

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click "Help" for information on to correct this error."

This applies to Microsoft Excel 2010 only.

Cause

Problem is caused by stale Microsoft files in C:\Documents and Settings\<user_name>\Application Data\Microsoft\Forms after applying following Microsoft Update: http://support.microsoft.com/default.aspx?scid=kb;en-us;932349

Solution

To workaround this issue:

1.  Close all Microsoft Applications.
2.  Navigate to C:\Documents and Settings\<user_name>\Application Data\Microsoft\Forms.
3.  Delete all .EXD files in this location.
4.  Start Microsoft Excel.
5.  Open the workbook that was throwing an error before.

References

@ BUG:10214728 - NEED EPMA 11.1.1.3.X TO SUPPORT OFFICE 2010
@ BUG:10632588 - NEED EPMA UTILITIES TO SUPPORT OFFICE 2010
NOTE:838337.1 - How to use the 11.1.1.2 EPMA File Generator to Generate ADS File on Current and Prior Versions for Hyperion Planning