Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    NJ
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2010 crashes when I use a keyboard short cut

    I ofter filter a data table to remove rows I don't want. I define the area then I invoke Alt A T which sets the filter drop downs. When I am done, I invoke Alt A T again to remove the filter but Excel crashes. It is not a because the file is corrupt - it happens on new files I am trying to create. I do this all the time at work - no problem. I am up to date with Office updates. Any ideas?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    RMS,

    Welcome to the Lounge as a new poster!

    I just tried it on my version of Excel 2010 and had no problems. You may want to try a repair install of Excel or Office. HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    NJ
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile

    Problem solved. Many thanks.

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    NJ
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I was too quick to respond. It worked like it supposed to for about an hour then it started behaving badly again. I did the repair install but it didn't last.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    225
    Thanks
    30
    Thanked 4 Times in 4 Posts
    Try it on a different PC. If it works on that, then you have either hardware or software corruption.

    Alan

  6. #6
    Silver Lounger mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    2,177
    Thanks
    207
    Thanked 213 Times in 205 Posts
    What version of Windows are you running? Did you recently upgrade to Windows 8.x? If so, is that when the problem started?

    Occasionally things don't work in Windows 8.x that worked in prior versions of Windows.

  7. #7
    New Lounger
    Join Date
    Dec 2009
    Location
    NJ
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm running Vista. I wonder now if it is me keyboard shorting out or something like that. I noticed on one crash that the crash occurred before I pressed T in the Alt A T sequence.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    Does it happen with every spreadsheet or only particular ones?

    Steve

  9. #9
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,292
    Thanks
    47
    Thanked 257 Times in 237 Posts
    Try bypassing the keyboard by using the sendKey method. Place in a standard module then run the macro through the Developer Tab> Macros> FilterKeys> Run


    Code:
    Public Sub FilterKeys()
    SendKeys "%at"
    End Sub

  10. #10
    New Lounger
    Join Date
    Dec 2009
    Location
    NJ
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the all of the suggestions. I think that the problem is is my keyboard. Sometimes the keyboard short cuts work, sometimes they cause Excel to crash. When it crashes, Excel is able to create a recovery file. When that happens, I just use the Filter icon on the Data tab until the file is saved.

  11. #11
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    RMS,

    Sounds like a good keyboard cleaning with some compressed air is in order before you replace the KB. HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •