Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
WDW WDW is offline
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

We just upgraded to Excel 2007 and Vista on some of our machines at work.
On some sheets when we select one cell multiple cells are selected. This
does not happen every time, but enough to be annoying. Hoe do we fix this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Click on single cell, multiple cells are selected.

I guess it's the same as Excel 2003 in which case try tapping F8.

Mikw

"WDW" wrote:

We just upgraded to Excel 2007 and Vista on some of our machines at work.
On some sheets when we select one cell multiple cells are selected. This
does not happen every time, but enough to be annoying. Hoe do we fix this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
WDW WDW is offline
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

Thanks, but that is not it.
We tried that (earlier suggestion from a different site). F8 was not
selected.
We also ran diagnostics and checked for updates. So far every once in a
while multiple cells "auo-select" with a single click.


"Mike H" wrote:

I guess it's the same as Excel 2003 in which case try tapping F8.

Mikw

"WDW" wrote:

We just upgraded to Excel 2007 and Vista on some of our machines at work.
On some sheets when we select one cell multiple cells are selected. This
does not happen every time, but enough to be annoying. Hoe do we fix this?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

Did you find a solution? We are experiencing the same issue on windows xp
machine running Office 2007. It seems to be very random and limited to only
a few different workbooks.

"WDW" wrote:

Thanks, but that is not it.
We tried that (earlier suggestion from a different site). F8 was not
selected.
We also ran diagnostics and checked for updates. So far every once in a
while multiple cells "auo-select" with a single click.


"Mike H" wrote:

I guess it's the same as Excel 2003 in which case try tapping F8.

Mikw

"WDW" wrote:

We just upgraded to Excel 2007 and Vista on some of our machines at work.
On some sheets when we select one cell multiple cells are selected. This
does not happen every time, but enough to be annoying. Hoe do we fix this?

  #5   Report Post  
Posted to microsoft.public.excel.misc
WDW WDW is offline
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

No I have not found a solution. It is random and limited here as well. I
have seen people asking this question for months now. No one has given a
good answer and MS has ignored it.

"Tim Paulsen" wrote:

Did you find a solution? We are experiencing the same issue on windows xp
machine running Office 2007. It seems to be very random and limited to only
a few different workbooks.

"WDW" wrote:

Thanks, but that is not it.
We tried that (earlier suggestion from a different site). F8 was not
selected.
We also ran diagnostics and checked for updates. So far every once in a
while multiple cells "auo-select" with a single click.


"Mike H" wrote:

I guess it's the same as Excel 2003 in which case try tapping F8.

Mikw

"WDW" wrote:

We just upgraded to Excel 2007 and Vista on some of our machines at work.
On some sheets when we select one cell multiple cells are selected. This
does not happen every time, but enough to be annoying. Hoe do we fix this?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

We have the same problem here with some of our spreadsheets.

when you click on one cell excel highlights the cell you seleted and 3 or
more below it in the same row! editing works as though you only have one cell
selected.

it gets worse though!......

if you zoom in a bit you select more cells with each click - zoom out far
enough and it works fine - you only select one cell with each click - i've
spent some time trawling the net to no avail.

It doesn't seem to affect new wokbooks only ones which have been knocking
around for a while - but i don't feel like starting from scratch with the
hundred or so template files we use here!

I am yet to find any acklowledgment of this issue from microsoft.

F8 and mouse drivers and office 2007 SP1 seem not to make any difference
whatsoever.
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

It also seems to only happen in page layout view

bizarre and annoying
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

Thanks Don,

this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software issue
related to selection of cells in page layout view with spreadsheets created
using previous versions - as stated in my earlier submissions.

unless every mouse in the company has an objection to working with old files
in page layout view mashing my mouse will probably only make things worse :-)




"Don Guillett" wrote:

Beat up your scroll mouse by tapping on the wheel. Don't be nice. Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark
wrote in message
...
We have the same problem here with some of our spreadsheets.

when you click on one cell excel highlights the cell you seleted and 3 or
more below it in the same row! editing works as though you only have one
cell
selected.

it gets worse though!......

if you zoom in a bit you select more cells with each click - zoom out far
enough and it works fine - you only select one cell with each click - i've
spent some time trawling the net to no avail.

It doesn't seem to affect new wokbooks only ones which have been knocking
around for a while - but i don't feel like starting from scratch with the
hundred or so template files we use here!

I am yet to find any acklowledgment of this issue from microsoft.

F8 and mouse drivers and office 2007 SP1 seem not to make any difference
whatsoever.



  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.

It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?

Dave

On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,

this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software issue
related to selection of cells in page layout view with spreadsheets created
using previous versions - as stated in my earlier submissions.

unless every mouse in the company has an objection to working with old files
in page layout view mashing my mouse will probably only make things worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice. Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when you click on one cell excel highlights the cell you seleted and 3 or
more below it in the same row! editing works as though you only have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with each click - zoom out far
enough and it works fine - you only select one cell with each click - i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been knocking
around for a while - but i don't feel like starting from scratch with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any difference
whatsoever.



  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Click on single cell, multiple cells are selected.

I have seen it on other forums - no solution out there by the looks of it - I
have installed SP1 and it doesn't seem to resolve this issue.

Office opens older files in 'Compatability mode' which is a joke. and even
after I convert the files to new 2007 format I still have the same problem.

Hopefully as this is an MS forum someone from MS might actually think about
reading some of this and offering either a solution or a 'we are very sorry
and working to resolve this issue' -

or what is more likely is that they have our licence fees already so now we
can just 'Go Hang' I resent paying huge sums for software prevents me from
selecting the data I want in the view I want. It's not asking too much really
is it? -

I bought the upgrade version and still have 2003 installed on my machine so
using that until MS sort it - or until MS pay me for my time to re-do all our
templates.



" wrote:

This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.

It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?

Dave

On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,

this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software issue
related to selection of cells in page layout view with spreadsheets created
using previous versions - as stated in my earlier submissions.

unless every mouse in the company has an objection to working with old files
in page layout view mashing my mouse will probably only make things worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice. Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when you click on one cell excel highlights the cell you seleted and 3 or
more below it in the same row! editing works as though you only have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with each click - zoom out far
enough and it works fine - you only select one cell with each click - i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been knocking
around for a while - but i don't feel like starting from scratch with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any difference
whatsoever.


  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default Click on single cell, multiple cells are selected.

Sounds like you might have a sticking Shift or Control Key on the Keyboard!

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------
"Mark Ryan" wrote in message
...
I have seen it on other forums - no solution out there by the looks of

it - I
have installed SP1 and it doesn't seem to resolve this issue.

Office opens older files in 'Compatability mode' which is a joke. and even
after I convert the files to new 2007 format I still have the same

problem.

Hopefully as this is an MS forum someone from MS might actually think

about
reading some of this and offering either a solution or a 'we are very

sorry
and working to resolve this issue' -

or what is more likely is that they have our licence fees already so now

we
can just 'Go Hang' I resent paying huge sums for software prevents me from
selecting the data I want in the view I want. It's not asking too much

really
is it? -

I bought the upgrade version and still have 2003 installed on my machine

so
using that until MS sort it - or until MS pay me for my time to re-do all

our
templates.



" wrote:

This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.

It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?

Dave

On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,

this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software

issue
related to selection of cells in page layout view with spreadsheets

created
using previous versions - as stated in my earlier submissions.

unless every mouse in the company has an objection to working with old

files
in page layout view mashing my mouse will probably only make things

worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.

Also,
sometimes the f8 key can give similar results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.

when you click on one cell excel highlights the cell you seleted

and 3 or
more below it in the same row! editing works as though you only

have one
cell
selected.

it gets worse though!......

if you zoom in a bit you select more cells with each click - zoom

out far
enough and it works fine - you only select one cell with each

click - i've
spent some time trawling the net to no avail.

It doesn't seem to affect new wokbooks only ones which have been

knocking
around for a while - but i don't feel like starting from scratch

with the
hundred or so template files we use here!

I am yet to find any acklowledgment of this issue from microsoft.

F8 and mouse drivers and office 2007 SP1 seem not to make any

difference
whatsoever.




  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

On Feb 13, 7:17*pm, "Saruman" wrote:
Sounds like you might have a sticking Shift or Control Key on the Keyboard!

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------"Mark Ryan" wrote in message

...



I have seen it on other forums - no solution out there by the looks of

it - I
have installed SP1 and it doesn't seem to resolve this issue.


Office opens older files in 'Compatability mode' which is a joke. and even
after I convert the files to new 2007 format I still have the same

problem.

Hopefully as this is an MS forum someone from MS might actually think

about
reading some of this and offering either a solution or a 'we are very

sorry
and working to resolve this issue' -


or what is more likely is that they have our licence fees already so now

we
can just 'Go Hang' I resent paying huge sums for software prevents me from
selecting the data I want in the view I want. It's not asking too much

really
is it? -


I bought the upgrade version and still have 2003 installed on my machine

so
using that until MS sort it - or until MS pay me for my time to re-do all

our
templates.


" wrote:


This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.


It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?


Dave


On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,


this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software

issue
related to selection of cells in page layout view with spreadsheets

created
using previous versions - as stated in my earlier submissions.


unless every mouse in the company has an objection to working with old

files
in page layout view mashing my mouse will probably only make things

worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.

Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when you click on one cell excel highlights the cell you seleted

and 3 or
more below it in the same row! editing works as though you only

have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with each click - zoom

out far
enough and it works fine - you only select one cell with each

click - i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been

knocking
around for a while - but i don't feel like starting from scratch

with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from microsoft..


F8 and mouse drivers and office 2007 SP1 seem not to make any

difference
whatsoever.- Hide quoted text -


- Show quoted text -



This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)
  #14   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default Click on single cell, multiple cells are selected.


Sometimes these critters just have to be taught who is the boss

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
On Feb 13, 7:17 pm, "Saruman" wrote:
Sounds like you might have a sticking Shift or Control Key on the
Keyboard!

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------"Mark
Ryan" wrote in message

...



I have seen it on other forums - no solution out there by the looks of

it - I
have installed SP1 and it doesn't seem to resolve this issue.


Office opens older files in 'Compatability mode' which is a joke. and
even
after I convert the files to new 2007 format I still have the same

problem.

Hopefully as this is an MS forum someone from MS might actually think

about
reading some of this and offering either a solution or a 'we are very

sorry
and working to resolve this issue' -


or what is more likely is that they have our licence fees already so now

we
can just 'Go Hang' I resent paying huge sums for software prevents me
from
selecting the data I want in the view I want. It's not asking too much

really
is it? -


I bought the upgrade version and still have 2003 installed on my machine

so
using that until MS sort it - or until MS pay me for my time to re-do
all

our
templates.


" wrote:


This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.


It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?


Dave


On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,


this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software

issue
related to selection of cells in page layout view with spreadsheets

created
using previous versions - as stated in my earlier submissions.


unless every mouse in the company has an objection to working with
old

files
in page layout view mashing my mouse will probably only make things

worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.

Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when you click on one cell excel highlights the cell you seleted

and 3 or
more below it in the same row! editing works as though you only

have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with each click -
zoom

out far
enough and it works fine - you only select one cell with each

click - i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been

knocking
around for a while - but i don't feel like starting from scratch

with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from
microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any

difference
whatsoever.- Hide quoted text -


- Show quoted text -



This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)

  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

This has nothing to do with the mouse hardware. Closing an re-opening
excel sometimes fixes it. If you click a cell and it selects several,
it does it on MouseDown, not on MouseUp. In fact, if you notice it has
selected several cells before you release the mouse button, and you
drag up a bit (if it has selected errant cells below) it will de-
select the others. It seems to me that it has something to do with the
hit-testing internal to excel, and may be from an interaction with the
mouse drivers. But, hey, this is something Microsoft should
acknowledge and deal with! I'm using Logitech mouse and software
4.24.99. Please, others with the same problem, what mouse software and
version are you using?

Bob Graham

On Feb 14, 5:04*am, "Don Guillett" wrote:
Sometimes these critters just have to be taught who is the boss

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...
On Feb 13, 7:17 pm, "Saruman" wrote:



Sounds like you might have a sticking Shift or Control Key on the
Keyboard!


--
Saruman


---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------*"Mark
Ryan" wrote in message


...


I have seen it on other forums - no solution out there by the looks of

it - I
have installed SP1 and it doesn't seem to resolve this issue.


Office opens older files in 'Compatability mode' which is a joke. and
even
after I convert the files to new 2007 format I still have the same

problem.


Hopefully as this is an MS forum someone from MS might actually think

about
reading some of this and offering either a solution or a 'we are very

sorry
and working to resolve this issue' -


or what is more likely is that they have our licence fees already so now

we
can just 'Go Hang' I resent paying huge sums for software prevents me
from
selecting the data I want in the view I want. It's not asking too much

really
is it? -


I bought the upgrade version and still have 2003 installed on my machine

so
using that until MS sort it - or until MS pay me for my time to re-do
all

our
templates.


" wrote:


This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.


It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?


Dave


On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,


this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software

issue
related to selection of cells in page layout view with spreadsheets

created
using previous versions - as stated in my earlier submissions.


unless every mouse in the company has an objection to working with
old

files
in page layout view mashing my mouse will probably only make things

worse :-)


"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice..

Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when youclickon one cell excel highlights the cell you seleted

and 3 or
more below it in the same row! editing works as though you only

have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with eachclick-
zoom

out far
enough and it works fine - you only select one cell with each

click- i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been

knocking
around for a while - but i don't feel like starting from scratch

with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from
microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any

difference
whatsoever.- Hide quoted text -


- Show quoted text -


This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)




  #16   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Click on single cell, multiple cells are selected.

On Feb 26, 12:00*pm, wrote:
This has nothing to do with the mouse hardware. Closing an re-opening
excel sometimes fixes it. If you click a cell and it selects several,
it does it on MouseDown, not on MouseUp. In fact, if you notice it has
selected several cells before you release the mouse button, and you
drag up a bit (if it has selected errant cells below) it will de-
select the others. It seems to me that it has something to do with the
hit-testing internal to excel, and may be from an interaction with the
mouse drivers. But, hey, this is something Microsoft should
acknowledge and deal with! I'm using Logitech mouse and software
4.24.99. Please, others with the same problem, what mouse software and
version are you using?

Bob Graham

On Feb 14, 5:04*am, "Don Guillett" wrote:



Sometimes these critters just have to be taught who is the boss


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message


...
On Feb 13, 7:17 pm, "Saruman" wrote:


Sounds like you might have a sticking Shift or Control Key on the
Keyboard!


--
Saruman


---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------**"Mark
Ryan" wrote in message


...


I have seen it on other forums - no solution out there by the looks of
it - I
have installed SP1 and it doesn't seem to resolve this issue.


Office opens older files in 'Compatability mode' which is a joke. and
even
after I convert the files to new 2007 format I still have the same
problem.


Hopefully as this is an MS forum someone from MS might actually think
about
reading some of this and offering either a solution or a 'we are very
sorry
and working to resolve this issue' -


or what is more likely is that they have our licence fees already so now
we
can just 'Go Hang' I resent paying huge sums for software prevents me
from
selecting the data I want in the view I want. It's not asking too much
really
is it? -


I bought the upgrade version and still have 2003 installed on my machine
so
using that until MS sort it - or until MS pay me for my time to re-do
all
our
templates.


" wrote:


This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.


It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?


Dave


On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,


this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software
issue
related to selection of cells in page layout view with spreadsheets
created
using previous versions - as stated in my earlier submissions.


unless every mouse in the company has an objection to working with
old
files
in page layout view mashing my mouse will probably only make things
worse :-)


"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.
Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when youclickon one cell excel highlights the cell you seleted
and 3 or
more below it in the same row! editing works as though you only
have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with eachclick-
zoom
out far
enough and it works fine - you only select one cell with each
click- i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been
knocking
around for a while - but i don't feel like starting from scratch
with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from
microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any
difference
whatsoever.- Hide quoted text -


- Show quoted text -


This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)- Hide quoted text -


- Show quoted text -


It doesn't appear to be caused by mouse hardware. I can recreate the
issue on a laptop without a mouse. I have updated with SP1 along with
the latest updates and it hasn't gone away. The only thing I know from
messing around with this is that it appears in Page Layout view. If
you change it to the Normal Layout view then it goes away. I guess I
will have to contact Microsoft on this one.

Bill
  #17   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Click on single cell, multiple cells are selected.

We are seeing this as well and have found that we can NOT repro it in Normal
view, but it can be reproduced regularly while in Page Layout view.

We have done this with different spreadsheets, after reboots and verifying
key sticking on keyboard or mouse are not the cause.

Any word on a resolution? For now we're going to be telling users to switch
to Normal View when editing documents where this is occurring!

" wrote:

On Feb 26, 12:00 pm, wrote:
This has nothing to do with the mouse hardware. Closing an re-opening
excel sometimes fixes it. If you click a cell and it selects several,
it does it on MouseDown, not on MouseUp. In fact, if you notice it has
selected several cells before you release the mouse button, and you
drag up a bit (if it has selected errant cells below) it will de-
select the others. It seems to me that it has something to do with the
hit-testing internal to excel, and may be from an interaction with the
mouse drivers. But, hey, this is something Microsoft should
acknowledge and deal with! I'm using Logitech mouse and software
4.24.99. Please, others with the same problem, what mouse software and
version are you using?

Bob Graham

On Feb 14, 5:04 am, "Don Guillett" wrote:



Sometimes these critters just have to be taught who is the boss


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message


...
On Feb 13, 7:17 pm, "Saruman" wrote:


Sounds like you might have a sticking Shift or Control Key on the
Keyboard!


--
Saruman


---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------Â*Â*"Mark
Ryan" wrote in message


...


I have seen it on other forums - no solution out there by the looks of
it - I
have installed SP1 and it doesn't seem to resolve this issue.


Office opens older files in 'Compatability mode' which is a joke. and
even
after I convert the files to new 2007 format I still have the same
problem.


Hopefully as this is an MS forum someone from MS might actually think
about
reading some of this and offering either a solution or a 'we are very
sorry
and working to resolve this issue' -


or what is more likely is that they have our licence fees already so now
we
can just 'Go Hang' I resent paying huge sums for software prevents me
from
selecting the data I want in the view I want. It's not asking too much
really
is it? -


I bought the upgrade version and still have 2003 installed on my machine
so
using that until MS sort it - or until MS pay me for my time to re-do
all
our
templates.


" wrote:


This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.


It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?


Dave


On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,


this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software
issue
related to selection of cells in page layout view with spreadsheets
created
using previous versions - as stated in my earlier submissions.


unless every mouse in the company has an objection to working with
old
files
in page layout view mashing my mouse will probably only make things
worse :-)


"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.
Also,
sometimes the f8 key can give similar results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.


when youclickon one cell excel highlights the cell you seleted
and 3 or
more below it in the same row! editing works as though you only
have one
cell
selected.


it gets worse though!......


if you zoom in a bit you select more cells with eachclick-
zoom
out far
enough and it works fine - you only select one cell with each
click- i've
spent some time trawling the net to no avail.


It doesn't seem to affect new wokbooks only ones which have been
knocking
around for a while - but i don't feel like starting from scratch
with the
hundred or so template files we use here!


I am yet to find any acklowledgment of this issue from
microsoft.


F8 and mouse drivers and office 2007 SP1 seem not to make any
difference
whatsoever.- Hide quoted text -


- Show quoted text -


This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)- Hide quoted text -


- Show quoted text -


It doesn't appear to be caused by mouse hardware. I can recreate the
issue on a laptop without a mouse. I have updated with SP1 along with
the latest updates and it hasn't gone away. The only thing I know from
messing around with this is that it appears in Page Layout view. If
you change it to the Normal Layout view then it goes away. I guess I
will have to contact Microsoft on this one.

Bill

  #18   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Click on single cell, multiple cells are selected.

A little more info... it appears that in our cases this problem occurs most
often (if not only) when not only in Page Layout view, but when the
spreadsheet has a footer with multiple lines of text in it.

As bentzb mentioned, this appears to happen on the mousedown event and based
upon how the behavior works if you hold the mouse button in and drag around,
it appears that for some reason the Excel code must have interpretted the
single click as a click and drag. This seems most likely to be being caused
by how cell positions on the screen are most likely being calculated in order
to display correctly while in Page Layout view.

"sgregpa" wrote:

We are seeing this as well and have found that we can NOT repro it in Normal
view, but it can be reproduced regularly while in Page Layout view.

We have done this with different spreadsheets, after reboots and verifying
key sticking on keyboard or mouse are not the cause.

Any word on a resolution? For now we're going to be telling users to switch
to Normal View when editing documents where this is occurring!

" wrote:

On Feb 26, 12:00 pm, wrote:
This has nothing to do with the mouse hardware. Closing an re-opening
excel sometimes fixes it. If you click a cell and it selects several,
it does it on MouseDown, not on MouseUp. In fact, if you notice it has
selected several cells before you release the mouse button, and you
drag up a bit (if it has selected errant cells below) it will de-
select the others. It seems to me that it has something to do with the
hit-testing internal to excel, and may be from an interaction with the
mouse drivers. But, hey, this is something Microsoft should
acknowledge and deal with! I'm using Logitech mouse and software
4.24.99. Please, others with the same problem, what mouse software and
version are you using?

Bob Graham

On Feb 14, 5:04 am, "Don Guillett" wrote:



Sometimes these critters just have to be taught who is the boss

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message

...
On Feb 13, 7:17 pm, "Saruman" wrote:

Sounds like you might have a sticking Shift or Control Key on the
Keyboard!

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------Â*Â*"Mark
Ryan" wrote in message

...

I have seen it on other forums - no solution out there by the looks of
it - I
have installed SP1 and it doesn't seem to resolve this issue.

Office opens older files in 'Compatability mode' which is a joke. and
even
after I convert the files to new 2007 format I still have the same
problem.

Hopefully as this is an MS forum someone from MS might actually think
about
reading some of this and offering either a solution or a 'we are very
sorry
and working to resolve this issue' -

or what is more likely is that they have our licence fees already so now
we
can just 'Go Hang' I resent paying huge sums for software prevents me
from
selecting the data I want in the view I want. It's not asking too much
really
is it? -

I bought the upgrade version and still have 2003 installed on my machine
so
using that until MS sort it - or until MS pay me for my time to re-do
all
our
templates.

" wrote:

This is definitely software related and widespread. We are
experiencing the same issue here on spreadsheets created in older
versions and then opened in Excel 2007. I was hoping MS Office Service
Pack 1 might address the issue. Has anyone else tried installing that?
It doesn't seem too promising but I figure its worth a try.

It was very difficult to find this discussion on the topic, much less
anything from Microsoft. Has anyone seen information on this
elsewhere?

Dave

On Feb 11, 10:25 am, Mark Ryan
wrote:
Thanks Don,

this problem appears on every machine I try it on with office 2007 -
regardless of hardware differences. this is definately a software
issue
related to selection of cells in page layout view with spreadsheets
created
using previous versions - as stated in my earlier submissions.

unless every mouse in the company has an objection to working with
old
files
in page layout view mashing my mouse will probably only make things
worse :-)

"Don Guillett" wrote:
Beat up your scroll mouse by tapping on the wheel. Don't be nice.
Also,
sometimes the f8 key can give similar results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mark Ryan" <Mark wrote in message
...
We have the same problem here with some of our spreadsheets.

when youclickon one cell excel highlights the cell you seleted
and 3 or
more below it in the same row! editing works as though you only
have one
cell
selected.

it gets worse though!......

if you zoom in a bit you select more cells with eachclick-
zoom
out far
enough and it works fine - you only select one cell with each
click- i've
spent some time trawling the net to no avail.

It doesn't seem to affect new wokbooks only ones which have been
knocking
around for a while - but i don't feel like starting from scratch
with the
hundred or so template files we use here!

I am yet to find any acklowledgment of this issue from
microsoft.

F8 and mouse drivers and office 2007 SP1 seem not to make any
difference
whatsoever.- Hide quoted text -

- Show quoted text -

This definately has to do with the scroll wheel. I beat the hell out
of it and it fixed it :)- Hide quoted text -

- Show quoted text -


It doesn't appear to be caused by mouse hardware. I can recreate the
issue on a laptop without a mouse. I have updated with SP1 along with
the latest updates and it hasn't gone away. The only thing I know from
messing around with this is that it appears in Page Layout view. If
you change it to the Normal Layout view then it goes away. I guess I
will have to contact Microsoft on this one.

Bill

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Worksheet Functions 2 March 28th 07 02:19 AM
Using a single cell value to repopulate multiple cells Chris_NetworkRail Excel Discussion (Misc queries) 8 March 28th 07 12:12 AM
How do I return the vale of multiple cells into a single cell Enterprise Todd Excel Worksheet Functions 3 October 11th 06 06:45 PM
extracting comma seperated from a single cell and auto populating in selected cells o guyvanzyl Excel Discussion (Misc queries) 6 July 3rd 06 03:19 PM
city, state, zip from a single cell to multiple cells wjs2002 Excel Discussion (Misc queries) 3 April 29th 05 07:02 AM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"