Excerl 2002...FInd and Replace not working properly
From jbclem1@21:1/5 to All on Mon May 3 22:27:51 2021
I have some large worksheets in Excel 2002 and I often use Control-F (Find
and Replace) to locate items. Lately it has been working erratically, and
more often than not produces this error message:
"Microsoft Excel cannot find the data you're searching for. Check your
search options, location, and formatting."
Closing and re-opening Excel isn't fixing this problem, it keeps
re-occurring.
Does anyone have an explanation for what triggers this, and a way I can get Find and Replace working properly again.