Problems with 'Find/ Replace'

Question

I am trying to use the "Find/ Replace" tool, but keep getting an error message telling me excel can't either find the match or "We couldn't find anything to replace. Click options for more ways to search. FYI: Its possible the data you're trying to replace is in a protected sheet. Excel can't replace data in protected sheets." However, the sheet is not protected and using Options doesn't work. Does anyone know what's going on and how to fix it?

Answer 1

Hi RLVonne. I am an Excel user like you.

The solution is probably in the options in the Find/Replace window. When you click on Options it opens up additional choices for how to search. Make sure that:

1. You are searching on this sheet.
2. You are searching by rows.
3. IMPORTANT: If the data is the result of a formula that you have selected values.
4. That the Match Case and Match contents boxes are not checked unless that is what you want.
5. That the format option says No Format Set. If it says anything else, use the Format dropdown to the right and click on "Clear Find Format".

Reply if you have additional questions or information. Please mark this reply as answered if this solves your question.

Rich~M

Answer 2

Yes, I have checked/ done all of those things and it still will not work.

Answer 3

My computer had an update this morning and now it works. Thanks for the help.

Answer 4

Glad you got it solved. Feel free to post back to the community whenever you need to.

Rich~M