+ Post New Thread
Results 1 to 15 of 15
Windows Thread, Strange Excel Problem in Technical; Hi All, Just came across a strange problem with excel. If I open any worksheet and click to select a ...
  1. #1
    Jon
    Jon is offline
    Jon's Avatar
    Join Date
    May 2006
    Location
    Norfolk
    Posts
    325
    Thank Post
    32
    Thanked 52 Times in 42 Posts
    Rep Power
    22

    Strange Excel Problem

    Hi All,

    Just came across a strange problem with excel. If I open any worksheet and click to select a cell I then can't deselect it! If I move the mouse around it is as if I am holding down the mouse button and simply selects any cells i drag over.

    The only way out is to right click on the task bar button and close the worksheet altogether.

    Anybody had this problem or know what might be causing it?

    Thanks in advance.

  2. #2

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Strange Excel Problem

    You may have Stick Keys enabled or is one of the shift keys stuck?

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,272
    Thank Post
    614
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412

    Re: Strange Excel Problem

    sticky shift button?

    hit the windows key several times.

    Ben

  4. #4
    Jon
    Jon is offline
    Jon's Avatar
    Join Date
    May 2006
    Location
    Norfolk
    Posts
    325
    Thank Post
    32
    Thanked 52 Times in 42 Posts
    Rep Power
    22

    Re: Strange Excel Problem

    Thanks for the quick answers thats great.

    The problem is not with the shift keys or sticky keys i'm afraid. This was my first guess but all is OK.

    After I have clicked into a cell I then can't do anything else in that sheet. No menus can be selected or close windows buttons either.

    The only way out is to close excel from the taskbar.,

  5. #5

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,282
    Thank Post
    225
    Thanked 403 Times in 300 Posts
    Rep Power
    161

    Re: Strange Excel Problem

    along the same lines as the other suggestions I'm afraid but try bashing all the shift, ctrl and windows keys repeatedly but seperately. We get this sometimes on kids machines so a security error pops up as it thinks the Windows key is held down.

  6. #6
    Jon
    Jon is offline
    Jon's Avatar
    Join Date
    May 2006
    Location
    Norfolk
    Posts
    325
    Thank Post
    32
    Thanked 52 Times in 42 Posts
    Rep Power
    22

    Re: Strange Excel Problem

    The machine this is happening on is the secretarys Laptop. The version of excel is office xp (2002).

    There is no problem with the sticky keys feature or keys being jammed down. I have disabled the touch pad and connected an external mouse but the problem is still there.

    No other programme or feature seems to be affected. 8O

    I think I will reinstall excel and see if the cures to problem

  7. #7

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168

    Re: Strange Excel Problem

    Have you looked at the ClickLock setting under mouse properties in control panel?

    Turning this on with a shortest possible delay gives the effect you are seeing.

  8. #8
    Jon
    Jon is offline
    Jon's Avatar
    Join Date
    May 2006
    Location
    Norfolk
    Posts
    325
    Thank Post
    32
    Thanked 52 Times in 42 Posts
    Rep Power
    22

    Re: Strange Excel Problem

    Thanks cadjs

    Clicklock would indeed have this effect...But it would also release when the mouse was clicked again :?

    The only way i can do anything is to move the pointer outside of the excel window, I can then right click on the taskbar and close excel

  9. #9

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Strange Excel Problem

    Go into Tools then Options then Edit tab and untick the Weird Stuff check box

    Seriously, rather than a full reinstall try the Office Detect and Repair optio n from Add and Remove Applications in Control Panel.

  10. #10

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168

    Re: Strange Excel Problem

    Ok then, how about pressing F8

    This turns on/off extended select mode and does something like you describe...although the cell can be deselected by clicking

    Maybe Excel is stuck in this mode...?

  11. #11

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168

    Re: Strange Excel Problem

    Have a look at http://forums.cnet.com/5208-6129_102...sageID=1271506

    There are some interesting ideas there

  12. #12

    CHR1S's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    4,486
    Thank Post
    1,570
    Thanked 459 Times in 300 Posts
    Rep Power
    212

    Re: Strange Excel Problem

    I had this happen to me once before, I did a reinstall and it worked fine but never did find out why.

  13. #13
    Jon
    Jon is offline
    Jon's Avatar
    Join Date
    May 2006
    Location
    Norfolk
    Posts
    325
    Thank Post
    32
    Thanked 52 Times in 42 Posts
    Rep Power
    22

    Re: Strange Excel Problem

    Thanks everyone for all your suggestions.

    I won't be back in the school untill Monday, I will let you know how I get on

  14. #14

    Join Date
    Jul 2011
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi
    I'm having the same problem but with Excel 2003, where sticky keys appear to be turned on, whether they are or not. This only happens from Excel, if you use any other office 2003 program, or anything else within windows it fine. I've tried restarting, reinstalled office, tried this as different user's but this has not fixed the issue.

  15. #15

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,648
    Thank Post
    1,775
    Thanked 2,159 Times in 1,597 Posts
    Rep Power
    768
    Have you tried giving the secretary a different keyboard and if that doesn't work, tried swapping the mouse?

    The last time I had similar problems, the keyboard got tipped upside down and received a good shake. Once the crumbs from several years of lunches had been removed along with a few staples, it worked much better!

SHARE:
+ Post New Thread

Similar Threads

  1. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 11:23 AM
  2. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM
  3. Strange Email Problem
    By richard in forum Windows
    Replies: 4
    Last Post: 15th June 2007, 06:58 AM
  4. Very strange problem...
    By Maxell in forum Windows
    Replies: 7
    Last Post: 5th February 2007, 04:01 PM
  5. Strange Word problem
    By richard in forum Windows
    Replies: 0
    Last Post: 21st February 2006, 12:47 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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