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: 552
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: 552
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

Post Reply