Problems searching for data in excel files using windows search

I have a client who is having issues searching for data in excel files. He is doing a windows search on a particular directory looking for specific key account numbers that are located in different excel spreadsheets. When he searches in certain directories the excel spreadsheets are not listing in the results even though he confirms that the searched data (mostly numeric) does exist in those spreadsheets. He does not have an issue in other direcotries that he searches in. All of the spreadsheets are saved in excel 2003 format.
Here is what he has tried so far.
Lorne,
  I've been testing further with the search problems and have found the following:
1. Re-Naming the file does not help the search find the number in a cell of an Excel file
2. Making a new file in the same directory does not work to find the number in a cell
3. Making a new file in a different directory does not work to find the number in a cell
4. Mixing letters and numbers allows the numbers to be found in a cell
5. Searching for words works consistently
6. Searching for numbers in cells in files in other directories does work
Let me know if you find something helpful.
Thanks,
Jim
williamstechnologygroupAsked:
Who is Participating?
 
williamstechnologygroupAuthor Commented:
One other note:
It appears they have narrowed the issue down to this
Numeric Searches on the directory do not work
Apha or Alpha/Numeric searches do.
On other directories all types of searches work (alpha, numberic, alpha/numeric)
0
 
war1Commented:
Hello williamstechnologygroup,

I have found in the past that Windows Desktop Search does not index everything.  Google Desktop Search does a better job of indexing data on your computer.

Hope this helps!
war1
0
 
williamstechnologygroupAuthor Commented:
If there are no other replys to this post I am going to close it
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
war1Commented:
williamstechnologygroup, is the answer not correct?
0
 
williamstechnologygroupAuthor Commented:
I appreciate the suggestion for an alternative product, but what I was hoping for was a solution to make the windows search feature work. It just doesn't make sense. some directories it works fine, others it does not. If the answer is that the Windows search feature is truely unreliable I can accept that, but I want to make sure there is not an O/S fix/patch or somethihng going on with a Office 2007 bug (of which there are many)
0
 
war1Commented:
Windows Desktop search does not index attachments to email.  Google Desktop Search.  That is why I recommended it.
0
 
williamstechnologygroupAuthor Commented:
The actual documents that he is searching are excel documents on a network share. There are no email attachments that are needing to be searched
0
 
war1Commented:
Index data on network share is different.  In Windows Search, you can specify which drive or network location to index.
0
 
williamstechnologygroupAuthor Commented:
We've confirmed that the search parameters and indexing is setup correctly. They are just having some weird things happen where it will find data in one directory and not in another on the same network share. Permissions are the same, everything is the same.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.