Knowledgebase: Planning
Epma Utility To Generate .Ads File Give Error: "Compile error in hidden module: ImportsWorkbook" in Microsoft Excel 2010 [ID 1297682.1] To Bottom
Posted by Priya Doyle on 26 October 2012 04:36 PM

 
Click to add to Favorites To BottomTo Bottom

Sep 20, 2012PROBLEMPUBLISHED3

 

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 
 
 
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: