The problem of find and replace not working in Excel occur if the following condition gets true. Why Won’t Find And Replace Work In Excel? It’s ok to get this “Microsoft Excel cannot find a match” error when the text that you need to replace actually won’t exist in the worksheet.īut if the replacing text exists in your worksheet and still it showing “Microsoft Excel cannot find a match” then it’s a problem. At that time, you may be stuck with the following error message: In the Microsoft Excel application when you select the Replace option from the dialog box of Find and Replace for replacing data already existing in your Excel worksheet. Microsoft Excel cannot find the data you’re searching for.Ĭheck your search options, location and formatting. What Happens When Excel Find And Replace Won’t Work?Īt the time using the Find utility to search for any specific Excel workbook data, you may start getting an error message like:
