Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selecting a Range (2002/97)

    A user has a wookbook, in a Pivot table he uses, in Excel 97, Shift + arrow keys to select the range of data. When he uses the same workbook in Excel 2002, the Shift arrow keys no longer work to select the range of data. Did this change in 2002?

    TIA,

    Jimmy Lee

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Selecting a Range (2002/97)

    Jimmy,

    Does the workbook use a RefEdit control on the worksheet or on a userform?
    Do you have the latest updates for OfficeXP / ExcelXP installed?

    Jim Cone
    San Francisco, CA

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selecting a Range (2002/97)

    Jimmy Lee,

    You posted similar questions in the Word forum. The behavior of the arrow keys has not been changed in Word 2002 and Excel 2002 compared to their 97 versions. The problems you describe make me suspect that there is something wrong with the keyboard. Has it been plugged in correctly, are there bent pins in the connector, etc.?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selecting a Range (2002/97)

    Now that you mention it, I had noticed the problem with RefEdit in Excel XP, but I hadn't paid much attention to it. The registry edit fixes the problem indeed, so thank you very much for pointing out the solution.

    But Jimmy Lee mentions that a user can't select a range in a pivot table in an Excel workbook using the keyboard. I had no problems with that (before the registry edit mentioned above), and in the Word forum he posted a question about a user not being able to open the dropdown list of combo boxes using the keyboard. That made me suspect the keyboard of that user's PC.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Selecting a Range (2002/97)

    A remote possibility to check is that the user doesn't have any of the Control Panel Keyboard Accessibility options activated, such as "Sticky Keys".
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selecting a Range (2002/97)

    Hi Hans and others,

    I had a friend ina different company try Pivot tables in Excel 2000; she said that she could no longer select the ranges using arrow keys. The original user said that he had to use the mouse or type the ranges in; either of which were sub-optimal to him.

    Also, I tried this on the same two laptops as in my Word posting.

    TIA,

    Jimmy

    PS I emailed the user about RefEdit but haven't heard back from him

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selecting a Range (2002/97)

    Hi Jim,

    I just heard from the user. He doesn't know what RefEdit is so doesn't think he used it when he developed the workbooks.

    It is Office XP SP2.

    As I said, a friend found the same (changed behaviour) in Excel 2000 pivot tables.

    Regards,

    Jimmy Lee

  8. #8
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Selecting a Range (2002/97)

    Hans,

    Well not quite...

    In OfficeXP Service Pack 2, one of the fixes was:

    "XL2002: Cannot Use Keyboard Shortcuts to Select RefEdit Ranges_You cannot use a keyboard shortcut to select RefEdit ranges."

    In my case and some others I know about, the service pack does not fix the problem.
    The solution, I found, is to apply the registry edit outlined in <!mskb=291110>Microsoft Knowledge Base Article 291110<!/mskb>.
    The article applies to XL2000 but also works for XL2002.

    Regards,

    Jim Cone
    San Francisco, CA

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selecting a Range (2002/97)

    I'm sorry, I can't explain this. I can select ranges with the keyboard in the worksheet itself, and in dialog boxes such as when creating a chart or pivot table. I'm using Excel 2002 SP-2.

    Still, it won't hurt to let the user apply the registry fix mentioned by Jim Cone. I have attached a file that can be used for this.
    - Right click the attachment and select Save Target As...
    - Save the file.
    - Change the extension of the file from .txt to .reg.
    - Open (double click) the file from Windows Explorer. Confirm that you want to modify the registry.

    Note: the file is meant for Excel 2002 aka XP. If you want to use it for Excel 2000, change the single occurrence of 10.0 to 9.0.

  10. #10
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selecting a Range (2002/97)

    Hi Hans,

    the reg entry fixed the problem on my test pc and for the user.

    Thanks for your help.

    regards,

    Jimmy

Posting Permissions

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