Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "Microsoft Excel Cannot Find the Data You're Searching For" Error Message When You Use the Find Command to Search in a Workbook

"Microsoft Excel Cannot Find the Data You're Searching For" Error Message When You Use the Find Command to Search in a Workbook

Symptoms

When you try to use the Find utility to search for data in an Excel workbook, you may receive an error message similar to the following:
Microsoft Excel cannot find the data you're searching for. Check your search options, location and formatting.

↑ Back to the top

Cause

This issue may occur if you are searching for text, values, or formatting that is contained in a filtered list, and the filtering criteria prevents the text, values, or formatting from being displayed.

↑ Back to the top

Workaround

To work around this issue, set the filter criteria to Show All on each worksheet in your workbook before you perform the search. To do this, follow these steps:
  1. Start Excel, and then open the workbook that you want to search.
  2. On the Data menu, point to Filter, and then click Show All.
  3. Repeat step 2 for each sheet in the workbook.
  4. Perform the search.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in Excel 2003.

↑ Back to the top

Keywords: kb, kberrmsg, kbbug, kbentirenet, kbfreshness2006, kboffice12no

↑ Back to the top

Article Info
Article ID : 813978
Revision : 9
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 93