In this video, you will read the solution when Find and Replace feature not working properly. This feature does not work when the worksheet of your Excel is password protected. This feature doesn’t work in protected worksheet. If your active Excel cells do not have a matching data. When you forgot to hit the Find All or Find Next option before clicking the Replace option, and also if you are looking for the values or text within the filtered list.
check this link: https://bit.ly/2Bxbh7J
https://bit.ly/2WUA0dU