View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Rylander[_2_] John Rylander[_2_] is offline
external usenet poster
 
Posts: 2
Default Viewing data in Excel while scrolling. Instead of the cell cou

Well, I'm using the trial version of Excel 2007. But I must emphasize, this
is something that has been true for me, alas, in all of Excel 2002, 2003, and
2007--maybe 2000, also, but I do not recall.

It has to be a holdover setting somewhere, I'd think, but I've no idea where.

Thanks for any suggestions.

John


"Dave Peterson" wrote:

If you find out what did it, please post back.

And the next time it happens, maybe look at Help|about to check the version of
excel. Maybe she has two versions of excel installed?????

wrote:

We have a lady in one of our remote offices having the same problem as
John is describing with the Excel 2003 live scrolling. Prior to last
week it worked fine, then all of a sudden when she scrolls using the
scroll bar the page doesn't move and she get's the little tooltip with
the row number on it. When she let's go of the mouse it jumps to that
row.

She's using Excel 2003 and also has a Dell Laptop, though I'm not sure
which model. I'm looking into that. She hasn't loaded any new software
or done any Office updates, but she thinks maybe it started when she
accidentally hit a couple keys at the same time. She isn't exactly
sure which keys she hit.

Is there maybe some undocumented hotkey combination that toggles this
feature on and off in later versions of Excel? I've been looking for
three days in various forums and the only thing I can find is several
posts by John here all describing the problem, but no one that knows
how to fix it.

George

On Mar 18, 9:22 pm, Dave Peterson wrote:
xl2k and below have the yellow row tooltips and no live scrolling.
xl2002 and xl2003 have no tooltips and live scrolling
xl2007 has both.

What version of excel are you using?





John Rylander wrote:

This feature has never worked for me on my current computer (Inspiron 9300,
ALL latest Windows XP Pro updates, nvidia GeForce 6800) even with newer
versions of Excel.

Is there any other way to turn this on? It's like once it got turned off
somehow, no version of Office will turn it back on, and I've no idea how to
overcome this. Very annoying, and very troublesome--this is an extremely
important feature for me, and no one--and I mean NO ONE (in my experience,
after querying many people over the last few years)--seems to have any idea
how to solve this problem.

Any ideas, even wild ones, would be nice. (Not including reformatting drive
C:.... That may resolve the problem, though: this machine is an upgrade from
an older machine with the same issue, and I used some PC Mover kind of stuff
to bring the old system setup over the to new machine--mutatis mutandis,
working fine in all respects except this one thing....)

Thanks for any best guesses--I will gladly send anyone who solves this some
candy. :)

"Dave Peterson" wrote:

Upgrade to a newer version of excel.

I think xl2k was the last version to show those yellow row tooltips when you
scrolled.

Xl2002 added the live scrolling.

RUSmiling wrote:

How do you change this feature?
When I scroll it shows the cell numbers.
I'd like to see the data scrolling instead.
We have several computers here and both options are setup. I can't find
where to change this feature as it would be more helpfull to see the data as
I scroll through the document.
Any help would be greatly appreciated.

Thank You
Rick

--

Dave Peterson

--

Dave Peterson- Hide quoted text -

- Show quoted text -


--

Dave Peterson