Number Lock On/OFF Issue

[SRadabaugh]

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?

[qml]

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?

[tulips82]

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]

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

[Oratia623]

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.

[jameswebber]

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

[sleepyEDB]

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

[qml]

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

[skinners666]

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

[sleepyEDB]

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


sleepy

[Martin Ryan]

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

[Wim Gielis]

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.

[lotsaram]

Still there in CX 10.1
Drives all the Controllers crazy.

[Martin Ryan]

How annoying. It's a minor thing but it's one that really winds people up.

[PDAZ]

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