×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

False positive from File | Open "Search" field

False positive from File | Open "Search" field

False positive from File | Open "Search" field

(OP)
I used the "Search" field in the Excel File/Open dialog to search for workbooks containing the word "curvature". I got some hits and opened them all. I could find the presence of "curvature" in all files except one. I use the workbook search tool (making certain that all sheets are visible) and it cannot find "curvature" in any worksheet. Searched in VBA sheets and there was nothing there either.

What might be driving this false alarm?

RE: False positive from File | Open "Search" field

(OP)
Thanks for the reply. However, of the dozen file results returned only one had the target word in its filename and I could find the target in the worksheets. My observation is that Windows Explorer (Win 7) and the Excel 2016 Open dialog (which probably uses Explorer) also search file contents, etc.

RE: False positive from File | Open "Search" field

I have Windows 7 Enterprise, and yes, it's supposed to search contents, but it sucks at it. I have TEXT files where it can't find things in their contents.

I've used dnGREP for some searches successfully, but it's got problems with binary files

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: False positive from File | Open "Search" field

I can't comment on the particular issue, or on earlier versions of Windows, but in my opinion the Windows Explorer search function, at least in Windows 8 and 10, is now excellent. As long as the folder and file type are set to be indexed it will do a full search on all text, and return results very quickly. You can also set up Windows Explorer to display a readable preview, which works for all office files and pdfs, and also displays very quickly.

See: Opening and searching pdf files from Excel
for examples and some code for searching from Excel.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: False positive from File | Open "Search" field

That's probably my problem; I don't have my disks indexed.

I've always been concerned about speed issues on the disks, since I have about 3 million files between my two primary disks.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close