When you search a Microsoft Excel workbook for data, you may receive the following error message:
Microsoft Excel cannot find the data you're searching
for. Check your search options, location and formatting.
↑ Back to the top
This behavior can occur if you are searching for text,
for values, or for formatting that is contained in a filtered list, and if the filtering
criteria prevents the text, the values, or the formatting from being displayed. This
behavior is by design.
↑ Back to the top
To work around this behavior, select each sheet,
set the filter criteria to Show All, and then perform the search.
Notes
To show all data in a
filtered list in Microsoft Office Excel 2003, click a cell in the filtered list. Then, point to Filter on the Data menu, and then click Show All.
To show all data in a filtered list in Microsoft Office Excel 2007, click the arrow in the column header in the filtered list, and then click Select All.
↑ Back to the top