Extend Selection Won't Turn Off


L

Lori

We've had this happen on several diff computers. The extend selection gets
turned on, from what I've been able to determine they do not press the F8.
They are simply entering data and then use the mouse to select a different
cell but it's anchored to the cell they were editing. Where ever they move
the mouse (up, down, right or left) it mearly selects cells, the menu items
and toolbar buttons can cannot be selected/clicked.

Pressing F8, Esc, Scroll lock don't clear the anchor.

I've had to end task on Excel (loosing data), delete the excell11.xlb file
(this I discovered through trial and error) and reboot the computer in order
to clear the anchor. Why the toolbar file should be effecting this I don't
know. But without deleting that file it doesn't clear.

We have one person this happens to quite frequently any ideas would be helpful
 
Ad

Advertisements

D

Dave Peterson

Any chance it's a sticky mouse.

Try banging gently on the buttons (including the wheelmouse button if you have
one).

If that doesn't help, how about swapping (temporarily???) mouses (mice???).
 
L

Lori

Dave~

We have all optical mice, we're talking ~10 computers of 200 have reported
the problem - our people don't use Excel alot. Some have reported the
problem only once, if it's a bad mouse that would also show up in other areas
and we haven't had to replace their mice. Good thought though any others?

~Lori
 
D

Dave Peterson

And nothing good happened when the problem occurred and you banged on the
buttons.
 
L

Lori

Dave~

I've had it happen on my computer - once. Trust me, banging the mouse or on
the keyboard did nothing. And knowing my users as I do, the banging I did on
my equipment was nothing compared to what some of them can do. (apparently
it's quite easy to crack the screen on a blackberry....)

We've looked into sticky keys on keyboards as well, not a problem.

It happened some time ago for me, I'm in Excel quite a lot - my happy place
you know - and it hasn't happened since. Still have the same mouse and
keyboard, both work fine.

Users haven't reported any other problems related to the mouse, so no, I do
not believe this to be a mouse issue.

~Lori
 
Ad

Advertisements

T

Tushar Mehta (Microsoft MVP Excel 2000-2008)

This has happened (and I expect will happen) to me on a very rarely
basis. I have never recalled how it started nor have been able to
replicate it.

In almost every case, I've gotten out of it by switching to another
application's window and switching back. On one (or was it two?)
occasions I have to restart Excel. Luckily, it has never required any
more work.

As Peo mentioned, you might want to check if an updated (or earlier)
mouse driver has any effect.
 
L

Lori

Peo~

I've been meaning to thank you for the information. My chronic user hasn't
reported since I deleted the xlb file. But I took a look at the posting and
compiled a checklist for the next time it happens.

~Lori
 
L

Lori

Peo~

Thank you again.

Another user called with the same problem and I ran down my checklist and
activating the draglog of the wheelmouse and the turning it off did the trick!

~Thank you again
Lori
 
Ad

Advertisements

Joined
Aug 9, 2019
Messages
1
Reaction score
0
Hi Lori,
I have been having the same issues! I have other coworkers who have mentioned this as well. Would you mind sharing the checklist you created?

Thanks,
Allison
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top