Mouse issues with Excel

  • Thread starter Thread starter Ysandre
  • Start date Start date
Y

Ysandre

Every now and then, our Excel wigs out. If you highlight a
cell, and move the mouse, it highlights everywhere the
mouse points.
The curser stays at the "plus" symbol, and you can't close
or select anything from the excel toolbar
(ie "file" "exit"). By the time you move the mouse to the
desktop toolbar, so you can right-click and close,
everything in the spreadsheet has been highlighted (max
rows and columns).
I tried hitting F8, that didn't work.
I deleted and reloaded the mouse drive, that didn't work
either.
Temp fix is to reboot (it's a server, so we hate doing
that), but the problem comes back every now and then.
Any ideas?
 
I've seen this problem on a number of machines. If you have a USB mouse,
try unplugging the mouse from the PC, wait a minute, then reconnect.
 
Thanks for the suggestion, but unfortunately it didn't
work.
Any other ideas?
-----Original Message-----
I've seen this problem on a number of machines. If you have a USB mouse,
try unplugging the mouse from the PC, wait a minute, then
Click to expand...
reconnect.
 
Ysandre

I've heard of this with a scroll wheel mouse. Usually, pressing the
scroll-wheel button sorts it.

Andy.
 
Hi Ysandre,
Interesting, not very often that this happens with a non wheel mouse,
but then wheel mice are now much more common.
We definitely want feedback from you.

If you have something that will fail every time, please save a copy of
that workbook.

These are some things that I think may be major contributors:
Do either of these look familiar.

Use of =cell("filename") without a cell reference instead of
=Cell("filename",A1) which is fine.

User defined function returning Document properties and
especially if Volatile is included..

Additional observations:
Do you sometimes see gridlines or color text that does not match the
current sheet. (You are looking at more than one sheet)

For additional information and short-term fix and just because something
works for you does not mean the same trick will work again. But since
you do not have a wheel mouse the most logical would seem to be:

Ctrl+PageDN all the way to the last sheet tab and then back to the
first sheet tab with Ctrl+PageUP.

Select all sheets (Group Sheets), select cell A1, and then most
important Ungroup your sheets ; otherwise any change to a sheet
will destroy do the same to the other sheets and probably destroy them.
Group All Sheets: right-click on sheet tab, Select All
Ungroup Sheets: right-click on sheet tab, Ungroup

The best course of action is to make sure you have the latest drivers for your mouse
some report that the manufacturer's drivers may not be the best driver
for them. So next time you report specify, make and model of mouse,
operating system and Service Pack, and version of Excel (Help About)

Additional Information:
http://www.mvps.org/dmcritchie/excel/ghosting.txt

For those with a wheel mouse, whether it helps alleviate this problem or
not I have my wheel button set for Enter not that horrid default
AutoScroll (default) this allow me to click on an option and possibly use Enter
for the next dialogbox without moving hand or mouse when you can Enter
is option.



HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Get a new mouse. That will fix the problem. There's a bad
piece of circutry in the one you are using now.
 
Back
Top