Number Lock On/OFF Issue

Post Reply
SRadabaugh
Posts: 1
Joined: Mon Sep 19, 2011 1:03 pm
OLAP Product: TM1 and Hyperion System 9
Version: version 10.1
Excel Version: 2007

Number Lock On/OFF Issue

Post by SRadabaugh » Mon Sep 19, 2011 1:15 pm

Using Excel 2007 with TM1. This is not really an issue but more like an annoyance. When ever Excel is opened the Num Lock is turned OFF. Is there an option or setting somewhere that would allow me to change this behavior?

User avatar
qml
MVP
Posts: 1086
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Number Lock On/OFF Issue

Post by qml » Mon Sep 19, 2011 1:40 pm

I've heard about this buggy behaviour of Excel 2007 before, but it was related to using SendKeys in VBA. Do you have any macros executed on workbook/application open that could be responsible for this?
Kamil Arendt

tulips82
Posts: 1
Joined: Wed May 23, 2012 6:52 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Number Lock On/OFF Issue

Post by tulips82 » Tue Jun 12, 2012 1:21 pm

Has anyone been able to solve this? I have users on microsoft excel 2010 and tm1 9.5.2. Everytime they use perspectives numlock turns off.

moby91
MVP
Posts: 215
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: Number Lock On/OFF Issue

Post by moby91 » Tue Jun 12, 2012 8:18 pm

As you are using Excel 2007, what happens when you disable the TM1 Ribbon Bar as outlined by some IBM Technotes ?


http://www-304.ibm.com/support/docview. ... wg21413700
Excel hangs or crashes with exception error message after upgrading to TM1 9.4 or higher

http://www-304.ibm.com/support/docview. ... wg21459558
Excel 2007 slowing down when TM1 Perspectives is active and connected

http://www-304.ibm.com/support/docview. ... wg21506333
Unable to print an Active Form from Perspectives: Blank/missing VB error

User avatar
Oratia623
Posts: 40
Joined: Mon Apr 27, 2009 5:36 am
OLAP Product: TM1/PA/CA
Version: V7.x to 2.0.9+
Excel Version: All
Location: Sydney, Australia

Re: Number Lock On/OFF Issue

Post by Oratia623 » Wed Jun 13, 2012 4:12 am

This issue is only apparent when using TM1 with a keyboard with a number pad (ie not a laptop keyboard)
One way that I have used to get around this was to use the following VBA code.
This checks if the Numlock button is off, and turns it back on if needed.

(Usual caveats of use at your own risk etc)

Code: Select all

Private Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long
Private Const NumlockKey = 144

Private Sub Workbook_Open()
     If GetKeyState(NumlockKey) = 0 Then
        SendKeys "{NUMLOCK}"
     End If
End Sub
In the case I was using it, I placed this code in a Workbook_Open macro in an Excel Add-in and placed this in the users XL start directory.
As it was as Add-in, it bypassed the need to enable the VBA code.
As it was in the Start Directory and in the Workbook_Open macro, it ran every time Excel opened.

I sucessfully tested this on Windows 7 with Excel 2007 & Excel 2010, however when running Win XP running Excel 2007 the SendKeys“{NUMLOCK}” didn’t do anything.
I never found an XP alternative as I didn't need to.
Paul Williamson
____________________________________________________________________________________
I came. I saw. I did not concur.

User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Number Lock On/OFF Issue

Post by jameswebber » Thu Jan 24, 2013 7:32 pm

I am also having this issue, although the code works, the CXL ribbon finishes loading after my vba workbook open code.
Is there anyway to know when the ribbon has finished loading to invoke this.

Also be careful with windows UAC.
I found it is better to wrap the send keys function

so instead of this

Code: Select all

        'SendKeys "{NUMLOCK}"
This may work better

Code: Select all

    CreateObject("WScript.Shell").SendKeys "{NUMLOCK}", True

User avatar
sleepyEDB
Posts: 6
Joined: Mon Jan 31, 2011 4:14 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Number Lock On/OFF Issue

Post by sleepyEDB » Tue Sep 10, 2013 3:05 pm

Hello,

I too am experiencing this annoyance after a recent upgrade to Windows 7. I am fine with the official IBM solution of disabling the TM1 ribbon as the only function I need is the Explorer button. Does anyone know if there's another way to access the Explorer button other than on the ribbon itself?

*** EDIT ***

Nevermind, I found a workaround just after making my post. There is a TM1 entry in my Add-Ins menu at the top of Excel which wasn't present until the tm1pRibbonX.xlam file has been renamed. It certainly isn't as pretty as the TM1 ribbon, but it works for me and prevents the Num Lock from turning off.

Thanks,


sleepy

User avatar
qml
MVP
Posts: 1086
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Number Lock On/OFF Issue

Post by qml » Tue Sep 10, 2013 3:25 pm

In this thread there is a good tip from Chris K.
Kamil Arendt

skinners666
Posts: 22
Joined: Wed Oct 05, 2011 2:50 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 10.0

Re: Number Lock On/OFF Issue

Post by skinners666 » Tue Sep 10, 2013 3:26 pm

This issue has been addressed in TM1 9.5.2 FP3 and TM1 10.1.1 FP1.

http://www-01.ibm.com/support/docview.w ... wg1PM26333

User avatar
sleepyEDB
Posts: 6
Joined: Mon Jan 31, 2011 4:14 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Number Lock On/OFF Issue

Post by sleepyEDB » Tue Sep 10, 2013 4:33 pm

Thank you both for the replies! I'll contact our TM1 server admin and notify them of FP1.


sleepy

User avatar
Martin Ryan
Site Admin
Posts: 1957
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Number Lock On/OFF Issue

Post by Martin Ryan » Mon Dec 09, 2013 8:25 pm

skinners666 wrote:This issue has been addressed in TM1 9.5.2 FP3 and TM1 10.1.1 FP1.

http://www-01.ibm.com/support/docview.w ... wg1PM26333
Has anyone else experienced the issue after upgrading to 10.1.1 FP1? We've upgraded and we're still having problems. Using Excel 2010 over Citrix.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer

Wim Gielis
MVP
Posts: 2421
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Number Lock On/OFF Issue

Post by Wim Gielis » Mon Dec 09, 2013 10:27 pm

Martin Ryan wrote:
skinners666 wrote:This issue has been addressed in TM1 9.5.2 FP3 and TM1 10.1.1 FP1.

http://www-01.ibm.com/support/docview.w ... wg1PM26333
Has anyone else experienced the issue after upgrading to 10.1.1 FP1? We've upgraded and we're still having problems. Using Excel 2010 over Citrix.

Martin
Sure, it's still there. Very annoying.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

lotsaram
MVP
Posts: 3386
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Number Lock On/OFF Issue

Post by lotsaram » Tue Dec 10, 2013 9:18 am

Still there in CX 10.1
Drives all the Controllers crazy.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
Martin Ryan
Site Admin
Posts: 1957
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Number Lock On/OFF Issue

Post by Martin Ryan » Fri Dec 13, 2013 12:30 am

How annoying. It's a minor thing but it's one that really winds people up.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer

PDAZ
Posts: 2
Joined: Mon Nov 24, 2014 7:02 pm
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: 2013
Location: Arizona

Re: Number Lock On/OFF Issue

Post by PDAZ » Tue Feb 02, 2016 4:34 pm

We've had the issue arise when we installed Office 2013. Has anyone found a solution other than disabling the toolbar?

Post Reply