Discussion Locked

Excel and the faulty find feature...

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a client who has discovered that he is getting false positives when he searches his excel files for various data. He is using the Open File, Tools, Find feature and searching through his 100+ excel files. We've done searches for contents of"RP-1000(L)" and get around 25 positive hits, yet when we search each of the files for that same info, it comes back that "RP-1000(L)" does not exist in this file. I'm confused and the end user is frustrated. He is running Office 2000 on a Windows2000 Professional system. HELP!!! ;-)

5 replies

by maxwell edison

Greetings,

that is a strange thing. Here's something you might try. Instead of using just "Find", use the "Find and Replace". Replace it (if it still finds that many) with something obviously unique (something like 1a2a3a...) to see where it re-occurs.

Just a thought.

Maxwell

This discussion is closed to new replies.