I hope this isn't too simple to warrant help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Incarcerate Bush - 25 Apr 2008 07:56 GMT

MS Office Excel 2003 (11.5612.5606)
----
I've been using Excel more-or-less as a popular music database.
Currently, this sheet contains 25,591 rows of data. I'd routinely
used the Find funtion to locate information ... but, the function
abruptly changed its behavior in an unfavorable way.

Previously, when a search string was located, the information was
centered in the window. Now, it is found and the cell's ID is show in
the top left ... but, the row has to be scrolled to manually.

Other sheets in the workbook are not affected, the Find functions as
expected in them.

Help would be appreciated.

Reply to this Message

Don Guillett - 25 Apr 2008 13:19 GMT

As ALWAYS post your code for comments

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> MS Office Excel 2003 (11.5612.5606)
> ----
[quoted text clipped - 11 lines]
>
> Help would be appreciated.

Reply to this Message

Incarcerate Bush - 26 Apr 2008 00:28 GMT

>As ALWAYS post your code for comments

No code involved, using Find in immediate mode.
Thanks.

Reply to this Message

Dave Peterson - 25 Apr 2008 15:03 GMT

I don't think I've ever seen excel behave this way when I do a manual Edit|Find.

(Are you doing this manually or in code???)

But maybe you could work around it by doing a Find All and just selecting one of
the results in the bottom portion of that dialog.

> MS Office Excel 2003 (11.5612.5606)
> ----
[quoted text clipped - 11 lines]
>
> Help would be appreciated.

Signature

Dave Peterson

Reply to this Message

Incarcerate Bush - 26 Apr 2008 00:28 GMT

>I don't think I've ever seen excel behave this way when I do a manual Edit|Find.
>
>(Are you doing this manually or in code???)
>
>But maybe you could work around it by doing a Find All and just selecting one of
>the results in the bottom portion of that dialog.

Thanks for the response. I am using the Edit/Find manual search.
I've never seen this behavior before either ... and as I said, the
other sheets in the workbook behave normally. I will try the Find
All. If that works for me I may have to get used to it. Strange,
huh?

------------------------

>> MS Office Excel 2003 (11.5612.5606)
>> ----
[quoted text clipped - 11 lines]
>>
>> Help would be appreciated.

Reply to this Message

Dave Peterson - 26 Apr 2008 00:54 GMT

I don't think that this is the cause, but do you have frozen panes or
window|split or even multiple windows going on?

How about worksheet protection?

Any macros running?

Can you open the workbook with macros disable to test it out?

(Yeah, I don't have a guess.)

> >I don't think I've ever seen excel behave this way when I do a manual Edit|Find.
> >
[quoted text clipped - 26 lines]
> >>
> >> Help would be appreciated.

Signature

Dave Peterson

Reply to this Message

Rate this thread: