How does one use " Excel as a database and not as a spreadsheet"? Is that relevant to the issue? I have not been able to replicate this with one of my sheets. I open the sheet and the find function works fine.

If you click options, are any of the check boxes checked or is the format clear. I guess that can't be the reason since it works for you immediately thereafter.