Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problems searching for data in excel files using windows search

Posted on 2009-02-20
9
Medium Priority
?
679 Views
Last Modified: 2012-05-06
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
0
Comment
  • 5
  • 4
9 Comments
 
LVL 97

Expert Comment

by:war1
ID: 23695840
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
 

Author Comment

by:williamstechnologygroup
ID: 23821670
If there are no other replys to this post I am going to close it
0
 
LVL 97

Expert Comment

by:war1
ID: 23822056
williamstechnologygroup, is the answer not correct?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 

Author Comment

by:williamstechnologygroup
ID: 23830579
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
 
LVL 97

Expert Comment

by:war1
ID: 23831203
Windows Desktop search does not index attachments to email.  Google Desktop Search.  That is why I recommended it.
0
 

Author Comment

by:williamstechnologygroup
ID: 23838049
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
 
LVL 97

Expert Comment

by:war1
ID: 23838314
Index data on network share is different.  In Windows Search, you can specify which drive or network location to index.
0
 

Author Comment

by:williamstechnologygroup
ID: 23838372
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
 

Accepted Solution

by:
williamstechnologygroup earned 0 total points
ID: 23838711
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question