Compile error in hidden module: mdlGlobal after upgrade to new Excel Add-in 11.0.1.15

  • Questions
  • Compile error in hidden module: mdlGlobal after upgrade to new Excel Add-in 11.0.1.15
Question ID: 104958
3
0

I just upgraded my Excel add-in to the latest version, which is 11.0.1.15 from the HPLN site.

Now when I try to open a spreadsheet file, I get error pop up: Compile error in hidden module: mdlGlobal"

Delete and reinstall did not help. I have used the Excel add-in in the past and not had any issues before.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on April 10, 2013 6:21 pm
45 views
Answers (2)
4
Private answer

The newest version of Excel Add-in, 11.0.1.15, from HP's Live Network site, list the following workaround for the error. They state that this can occur for an install without admin privileges, but I have seen this error occur when an admin was logged on a workstation and ran the install. But the fix was used as suggested and corrected the issue from occurring.

Error: ''Compile error in hidden module: mdlGlobal''

From the new readme for 11.0.1.15:

Error when Opening Excel: If you installed the HP ALM Microsoft Excel Add-in without administrator privileges, you may receive the ''Compile Error in hidden module: mdlGlobal'' error when you open Excel. The Windows Common Controls mscomctl.ocx file has become un-registered. To resolve this issue, either:

- Repair or reinstall Microsoft Office. By default the mscomctl.ocx file is registered when Microsoft Office is installed.

- Manually register the mscomctl.ocx file:
- For 64bit OS, run the following command in the cmd window with administrator privileges:
Regsvr32 c:windowssyswow64mscomctl.ocx

- For 32bit OS, run the following
command in the cmd window with
administrator privileges: Regsvr32
c:windowssystem32mscomctl.ocx**

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on April 10, 2013 6:24 pm
That fix did the trick. Thanks!
( at April 11, 2013 3:13 pm)
2
Private answer

Our users do not have admin rights for command prompt. is there another way to get around this issue?

Marked as spam
Posted by (Questions: 26, Answers: 22)
Answered on January 30, 2014 3:39 pm
Well you can have a local admin put it to each machine or profile, or perhaps easier, would be to run a repair of the MS Office from control panel. The repair should get all files registered. It really is a matter of figuring out the best method of applying either fix and having it spread to the users, based on their specific user profile permissions.
( at January 30, 2014 3:44 pm)
Repair option might be a good way to go. I will have to check on that avenue. Thank you for the suggestion.
( at January 30, 2014 3:46 pm)