Page 1 of 1

Runtime Error in Excel 2010

Posted: Tue Jul 22, 2014 7:17 pm
by konjis1
We have a user who enables the TM1P.xla add-in for Excel 2010. The issue we are running into is that when this user opens an Excel spreadsheet that was an attachment in Outlook, they receive a VB Runtime error of "Method 'Onkey' of object'_Application' failed" once the spreadsheet comes up. I pinpointed it to the add-in because when this add-in is disabled he does not receive the error.

The really weird thing is he only receives this error when he opens the spreadsheet from Outlook. If he opens a spreadsheet that is stored locally or on a shared drive, this error does not occur even when the tm1p.xla add-in is enabled.
Any thoughts on what may be happening or how to resolve this? I am at a stand still at this point.


We are running Windows 7
Microsoft Office 2010
Cognos Express 10.2.1 w/Xcelerator

Thank you in advance!

Re: Runtime Error in Excel 2010

Posted: Tue Jul 22, 2014 8:11 pm
by jim wood
A couple of things:

1) Why not just go with the tm1p.xla?
2) Have you tried changing the macro security levels?

Jim.

Re: Runtime Error in Excel 2010

Posted: Tue Jul 22, 2014 8:25 pm
by konjis1
Jim,

We are going with the tm1p.xla....that is the issue. When it is enabled, the error occurs when opening a spreadsheet that was an attachment within Outlook.

Re: Runtime Error in Excel 2010

Posted: Wed Jul 23, 2014 6:34 am
by wilsonmax
May I know if the Office/Excel 2010 is 32 or 64 bits?

Re: Runtime Error in Excel 2010

Posted: Wed Jul 23, 2014 9:48 pm
by konjis1
Excel 2010 64 bit

Re: Runtime Error in Excel 2010

Posted: Thu Jul 24, 2014 1:05 am
by wilsonmax
konjis1 wrote:Excel 2010 64 bit
It seems that 32-bit Excel only supported

Reference
Productivity Applications > MS Excel > Notes
http://www-969.ibm.com/software/reports ... 79430418#!

Re: Runtime Error in Excel 2010

Posted: Thu Jul 24, 2014 1:47 am
by Alan Kirk
wilsonmax wrote:
konjis1 wrote:Excel 2010 64 bit
It seems that 32-bit Excel only supported

Reference
Productivity Applications > MS Excel > Notes
http://www-969.ibm.com/software/reports ... 79430418#!
For Perspectives, 64 bit excel is only supported from 10.2.2.