Excel 2007 Find and Replace Scroll Issues

L

Liz Stinaff

Spreadsheet: 4.0 MB with 16,000 records and 60 columns created
originally in
2003, copied as values into new book and saved as 2007 file (the 2003
version
was 19 MB).

Problem: I am having the same issue with the 2003 and 2007 file.

Here's what happens: I place my cursor on a cell, Ctrl+C and then
open Find
and Replace (Ctrl+F) and paste in what I'm looking for (Ctrl+V). I
scroll to
the top of the column, click to highlight the entire column and then
hit Find
All and then Find Next. Each time I hit Find Next, the cell location
area
displays the next occurrence but the page has not jumped to the next
occurrence location. So let's say Find All locates cells A100, A200,
A350
and so forth. The page I see is rows 1-43 each time I hit Find Next.
The
scroll bar moves and the cell location window displays each occurrence
but
the page has not moved. I use the mouse to click on the title bar to
switch
from Find/Replace back to the spreadsheet. Since the page did not
move to
the next location I use the up and down arrows to find the cursor.
Upon
doing this, the information in the cell that I see does not match the
information in the formula bar. Also, when moving the cursor up and
down the
Row numbers begin to change. I have found that I am typing over
information
I do not want to change. I have to page up and down several times to
get the
page to "refresh" and display the correct information.

Anyone else having the same issue??

Thanks!! Liz :)
 
J

Jim Rech

I could not reproduce this problem. It does seem to be video driver
related. Do you have the latest for your card?

--
Jim
| Spreadsheet: 4.0 MB with 16,000 records and 60 columns created
| originally in
| 2003, copied as values into new book and saved as 2007 file (the 2003
| version
| was 19 MB).
|
| Problem: I am having the same issue with the 2003 and 2007 file.
|
| Here's what happens: I place my cursor on a cell, Ctrl+C and then
| open Find
| and Replace (Ctrl+F) and paste in what I'm looking for (Ctrl+V). I
| scroll to
| the top of the column, click to highlight the entire column and then
| hit Find
| All and then Find Next. Each time I hit Find Next, the cell location
| area
| displays the next occurrence but the page has not jumped to the next
| occurrence location. So let's say Find All locates cells A100, A200,
| A350
| and so forth. The page I see is rows 1-43 each time I hit Find Next.
| The
| scroll bar moves and the cell location window displays each occurrence
| but
| the page has not moved. I use the mouse to click on the title bar to
| switch
| from Find/Replace back to the spreadsheet. Since the page did not
| move to
| the next location I use the up and down arrows to find the cursor.
| Upon
| doing this, the information in the cell that I see does not match the
| information in the formula bar. Also, when moving the cursor up and
| down the
| Row numbers begin to change. I have found that I am typing over
| information
| I do not want to change. I have to page up and down several times to
| get the
| page to "refresh" and display the correct information.
|
| Anyone else having the same issue??
|
| Thanks!! Liz :)
 

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