Find Fast Vs. Find Not-so-fast
 

I have a spreadsheet that has about 11000 rows of data. Previously, I would
hit Ctrl-F (Find) and type something in and it would immediately tell me
nothing was found or put me on the first found cell. But now, in the upper
left-hand corner, I see it processing rows and columns searching and then it
finally "lights" on a match and stops. It is MUCH slower. Any ideas why the
change and is it possible to get it back to the way it was previously?

Find Fast Vs. Find Not-so-fast
 

"Mike H." wrote in message
...
I have a spreadsheet that has about 11000 rows of data. Previously, I
would
hit Ctrl-F (Find) and type something in and it would immediately tell me
nothing was found or put me on the first found cell. But now, in the
upper
left-hand corner, I see it processing rows and columns searching and then
it
finally "lights" on a match and stops. It is MUCH slower. Any ideas why
the
change and is it possible to get it back to the way it was previously?


I use Excel 2000, and in the Find box I can choose to search by rows or
columns. Have you tried both ways to see if one works faster for your sheet?

Find Fast Vs. Find Not-so-fast
 

The Row/Column did not make any difference, but the Look In (Formulas,
Values, Comments) sure did. I changed it from Values to Formulas and it
finds my string INSTANTLY. The text I am searching for is not a formula but
it sure finds it faster.

"JoeSpareBedroom" wrote:

"Mike H." wrote in message
...
I have a spreadsheet that has about 11000 rows of data. Previously, I
would
hit Ctrl-F (Find) and type something in and it would immediately tell me
nothing was found or put me on the first found cell. But now, in the
upper
left-hand corner, I see it processing rows and columns searching and then
it
finally "lights" on a match and stops. It is MUCH slower. Any ideas why
the
change and is it possible to get it back to the way it was previously?


I use Excel 2000, and in the Find box I can choose to search by rows or
columns. Have you tried both ways to see if one works faster for your sheet?