Thursday, June 14, 2012

OSI PI DataLink and Excel 2007 Error

Ugh.

Recently, my Excel 2007 would launch with these annoying errors:
  • Compile error in hidden module: Main
  • Compile error in hidden module: modAddin OSI PI Tag Configurator error
  • Object library invalid or contains references to object definitions that could be found OSI PI Datalink error
Useful error messages, huh?

After boggling at these gems of clarity, any typical user simply stops using Excel (if possible).

But if Excel is a daily workhorse of productivity, the next path of least resistance is to disable the Add-Ins.

Still using Excel to store Cell Culture Data?

Of course, if access to tabular OSI PI data (DataLink) or bulk tag configuration (Tag Configurator), your only option is to fix this Excel 2007/OSI PI Add-In error.

How to fix

You simply need to delete the Forms directory:
  • For Windows XP:
    C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms
  • For Windows Vista, Windows 7:
    C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms
Did that work? It usually does.

If not, try this.





If you use OSI PI, check out: ZOOMS Search Engine

12 comments:

Anonymous said...

that didn't help for me :(

Oliver Yu said...

Sorry to hear. Did you also Repair PI DataLink?

Anonymous said...

Excellent ! this fixed my problem

Shane said...

I have the PI ProcessBook Datalink add-in for Excel. I had this problem whenever I would open or close Excel. I found out that it was linked to a recent automatic update of "Microsoft Office 2003 Web Components". Go to add/remove programs, right click, and repair the web component installation.

Anonymous said...

yes and didn´t solve the problem

GJBenzie said...

Hello all,

I have run into this error and tried the above suggestions to no avail. Below is what worked for me.

If on a 64-bit machine
Type the following:

regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX


Press Enter.

Then type:

regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX

If on a 32-bit machine
Type the following:

regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX


Press Enter.

Then type:
regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX

Hope it helps!

Spoke said...

Thanks GJ, I'd had this problem before & got past it by deleting MSComctlLib.exd but this time it didn't work but using your solution fixed the problem for me.

Oliver Yu said...

Yup, me too. I put it in a post so people don't have to dig through comments to find this great solution. Lemme know if you need a linkback to you:

http://blog.zymergi.com/2012/08/compile-error-in-hidden-module-modaddin.html

Anonymous said...

Dear Sir,

We have same problem, when open Excel2007,
error messages from Microsoft Forms show as below.
Could not load an object because it is not available on this machine.
error messages from Microsoft Visual Basic show as below.
Compile error in hidden module: atProcessDataXL
I type as below.
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
Restart PC, Open Excel2007 remain show error.
Help to verify.

Anonymous said...

It looks as though you are doing the register/unregister order in reverse.

1. regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
un registers the ocx file

2. regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX
registers the file again

There should be no need to restart the machine.

Anonymous said...

it worked like a charm, thnx !

Martin Spalding said...

I tried this without success. First I typed in:
regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX

and that seemed to work fine.

However when I typed in:
regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX

I get the error message:
The module "C:\Windows\SysWOW64\MSCOMCTL.OCX" was loaded but the call to DllRegisterServer failed with error code 0x8002801c.

I can't seem to get around this.

-->