Forums Home

Thread Tools Display Modes
Old 19-Apr-2011, 5:13 am   #1
FaultWire's Avatar
Join Date: Mar 2008
Posts: 14,568
Invalid Microsoft Excel - Microsoft Office Excel cannot find the data ...

Dialog text:
Microsoft Office Excel cannot find the data you're searching for.

If you search a workbook for data you know exists, but the data is not found by the Find dialog, it is possible the data is in a filtered list. The configuration of the filtered list's search criteria is possibly preventing the data from being displayed. Filtered lists do not automatically revert to a Show All state when you attempt a search and therefore do not display the information when it is found, since the filtered list is expected to show only what it is set to display. To allow for a search of all data within a workbook, you must set the filter criteria for each filtered list to Show All prior to performing a search.
To show all data in filtered lists for an entire worksheet: click the upper left block where the numbered and lettered columns intersect to highlight the entire sheet, click Data on the menu, select Filter, and then click Show All.

Issued by: Microsoft Office 2003
Vendor: Microsoft Corporation

Jump to the FaultWire page for Solutions and Fixes for this topic...

FaultWire is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. This page opened at 4:48 pm.

  Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.