MarcherConsults

Q: Numeric keypad doesn't work in Excel after El Capitan install

I just installed El Capitan on my MacBook Air and now find that my usb-connected numeric keypads do not work in Excel ( I have two and neither works properly ).  The do work in Notes and in Word, just not in Excel for Mac 2011.  When I enter a number it appears briefly and automatically backspaces.  If I hold down a number key a series of numbers will appear in the cell and when I stop the last entered number is backspaced out.  Microsoft support was no help.

MacBook Air (13-inch Late 2010), OS X El Capitan (10.11), Excel for Mac 2011

Posted on Oct 6, 2015 7:49 AM

Close

Q: Numeric keypad doesn't work in Excel after El Capitan install

  • All replies
  • Helpful answers

  • by rpatinha,

    rpatinha rpatinha Oct 15, 2015 3:45 AM in response to MarcherConsults
    Level 1 (0 points)
    Oct 15, 2015 3:45 AM in response to MarcherConsults

    Hi,

     

    I just bought and return a numpad because of this issue.

     

    Have you tried this? http://ccm.net/forum/affich-415898-number-pad-not-working-in-excel

  • by MarcherConsults,Helpful

    MarcherConsults MarcherConsults Oct 15, 2015 7:38 AM in response to rpatinha
    Level 1 (6 points)
    Oct 15, 2015 7:38 AM in response to rpatinha

    A good try but it doesn't work.  I just completed a chat with Targus and learned that the Targus AKP11US and AKP10US devices that I have been happily using are incompatible with El Capitan and unless they find a workaround or issue a driver update there is no way to make them work. Why oh why did I upgrade to El Capitan?  My machine was working fine and now this.  It materially affects my ability to get work done.

  • by imblue14,

    imblue14 imblue14 Jan 7, 2016 8:45 AM in response to MarcherConsults
    Level 1 (0 points)
    Jan 7, 2016 8:45 AM in response to MarcherConsults

    FIX FOR AUTO BACKSPACE.

     

    Goto Excel as my Keypad which is from TARGUS Company.

    click on any cell and then start pressing keys on TARGUS KEYPAD in a Mad Way like you want to try all the keys out.

     

    Keep punching in and then hold and press keys down as much as you can with your 4 or 5 finger and release.

     

    Delete what ever you typed and then Check by typing any Numeric Key , it works everytime for me when ever i disconnect the keypad from my Macbook Air 2014.

     

    hope it works for you all....

  • by MarcherConsults,

    MarcherConsults MarcherConsults Jan 7, 2016 10:38 AM in response to imblue14
    Level 1 (6 points)
    Jan 7, 2016 10:38 AM in response to imblue14

    Nope, didn't work.  I think the issue is with Targus and until they release a new driver it will just continue to do this.

  • by Polemarch,Helpful

    Polemarch Polemarch Feb 10, 2016 4:55 PM in response to MarcherConsults
    Level 1 (10 points)
    Feb 10, 2016 4:55 PM in response to MarcherConsults

    Just got a new computer with El Capitan and noticed my Targus number pad sending clear keystrokes before and after every number press. It seems to be wanting to send num lock strokes for whatever reason.

     

    Look into a program called Karabiner. It offers a variety of key remapping features, but one of them is "Disable NumLock key." This has restored operation to normal for me. When Karabiner is running, click its icon in the toolbar (a little square) and select preferences. This should open to Karabiner's "Change Key" tab. The option you want is found under For PC Users -> Change PC NumLock Key. But you can also simply type "numlock" in the search field and look for it.

     

    Hope that helps!

  • by Apple-IIe,

    Apple-IIe Apple-IIe Feb 21, 2016 11:30 AM in response to Polemarch
    Level 1 (0 points)
    Feb 21, 2016 11:30 AM in response to Polemarch

    Thanks for finding this 'work-around'  Karabiner solved the problem

  • by mathchique,

    mathchique mathchique Mar 6, 2016 5:44 PM in response to MarcherConsults
    Level 1 (0 points)
    Mar 6, 2016 5:44 PM in response to MarcherConsults

    I had the same problem. By chance, I tried using the device with Google Sheets and it worked perfectly on both my macbook pro and my desktop iMac. Both operating systems are El Capitan, OSX11.3

     

    Since Google has really improved their office products, this work-around is alright with me. MS came out with a new office suite this year... I'm still using the 2011 version. But the Google version if free.

  • by bgreen1953,

    bgreen1953 bgreen1953 Mar 13, 2016 4:34 PM in response to Polemarch
    Level 1 (0 points)
    Mar 13, 2016 4:34 PM in response to Polemarch

    Thanks Polemarch!  That worked for me, too.  Mid-2012 MacBook Pro with El Capitan.  Was very frustrated with hundred of numbers to enter and a dysfunctional keypad.

    Karabiner seems quite complex to configure, so I appreciate the exact instructions you gave.

  • by mands33,

    mands33 mands33 Jun 2, 2016 8:48 PM in response to Polemarch
    Level 1 (4 points)
    Jun 2, 2016 8:48 PM in response to Polemarch

    thank you! this fixed my problem and was easy to follow with your instructions

  • by pablo288,

    pablo288 pablo288 Jun 29, 2016 2:16 PM in response to Polemarch
    Level 1 (4 points)
    Mac OS X
    Jun 29, 2016 2:16 PM in response to Polemarch

    Works for me! Thanks!