Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post Reply
ngphong
Posts: 6
Joined: Thu Jun 22, 2017 5:17 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 365

Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by ngphong » Tue Nov 28, 2017 7:14 pm

Hi:
I am installing TM1 Perspectives. When I do the Excel Add-in, after I map the IBM Cognos TM1 Perspectives (in the Excel Add-ins window) to tm1p.xla file, I got the message "can't find DLL entry point LoadLibraryA in Kernel32.dll". The TM1 Add-in does not show in Excel. I tried deleting and re-installed both Excel 365 (32-bit) and TM1 (10.2.2) a couple times, but the problem still there. This is the first time I see such issue. Has anyone run into this issue before?

User avatar
paulsimon
MVP
Posts: 648
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

Re: Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by paulsimon » Tue Nov 28, 2017 9:34 pm

Hi

Did you by any chance select the option to copy the AddIn to the AddIns folder? This might be causing the error since all DLLs related to the TM1P.XLA need to be in the same folder.

Regards

Paul Simon

ngphong
Posts: 6
Joined: Thu Jun 22, 2017 5:17 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 365

Re: Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by ngphong » Tue Nov 28, 2017 9:39 pm

Thank you, Paul.

Can you provide more details for me to check? Where can I find the AddIns folder?

Thanks,
Phong Nguyen

User avatar
paulsimon
MVP
Posts: 648
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

Re: Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by paulsimon » Tue Nov 28, 2017 10:51 pm

On my machine it is

C:\Program Files (x86)\Microsoft Office\root\Office16\ADDINS

ngphong
Posts: 6
Joined: Thu Jun 22, 2017 5:17 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 365

Re: Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by ngphong » Tue Nov 28, 2017 11:02 pm

Thanks. I see some add-ins subfolder under the Addins folder that you referenced, i.e. Power Map Excel Add-in, Power View Excel Add-in, PowerPivot Excel Add-in. Under each of those folders, there are verious .DLL files. I am not good enough to understand what are those .DLL files are for, and how are they related to the TM1P.XLA file.

Do you think I should try to re-install Excel and watch out for the option to copy the addins to the Addin folder?

Thanks,
Phong Nguyen

MichaelGlinski
Posts: 4
Joined: Fri Jun 08, 2012 7:27 pm
OLAP Product: TM1
Version: 10.2.2+
Excel Version: 2010-2016

Re: Can't Find DLL entry point LoadLibraryA in Kernel32.dll

Post by MichaelGlinski » Wed Aug 15, 2018 7:23 pm

FYI, in case anyone else runs into this error message in the future...

The exact error message discussed in this thread was being returned when a user tried running Perspectives on their machine. We tried reinstalling Perspectives, reinstalling Excel, re-registering DLLs, copying DLLs to Excel's ADDINS folder... all with no success.

It turns out the problem was that the user was on a network with a company-wide security policy to blacklist macros unless a specific .xla or .xlam file was whitelisted. These blacklists/whitelists even overrode any security settings we made in Excel, so while we thought we were allowing or telling Excel to notify us of macros via settings in Excel, we really weren't. The company-wide security policy overrode any configurations we made in Excel and prevented tm1p.xla from calling macros in a manner that resulted in the "Can't find DLL entry point LoadLibraryA in Kernel32.dll" message, which isn't typically what you see when macros are disabled.

After having a domain administrator whitelist "(user machine's name)\Program Files (x86)\ibm\cognos\tm1\bin\tm1p.xla", everything worked flawlessly.

I figured it would be worth posting some closure in this thread, since this error message isn't typically what you see when macros are being blocked and the previously described solution didn't work for me.

Post Reply