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,175
    Thanks
    200
    Thanked 781 Times in 715 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,155
    Thanks
    204
    Thanked 209 Times in 201 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,224
    Thanks
    14
    Thanked 341 Times in 334 Posts
    Does it happen with every spreadsheet or only particular ones?

    Steve

  9. #9
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,196
    Thanks
    45
    Thanked 227 Times in 210 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,175
    Thanks
    200
    Thanked 781 Times in 715 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
  •