+ Reply to Thread
Results 1 to 7 of 7

Error message when trying to search

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    3

    Error message when trying to search

    Got a strange question. I have always had the option to search in .xlsm but all of a sudden when I try and do it today, I get the error "We couldn't find what you were looking for. Click options for more ways to search." I am searching within cells that I know contain the item I am looking for in a multi-sheet .xlsm but still coming back with this error. Any clues?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Error message when trying to search

    Hi and welcome to the forum

    What are you using for the search...CTRL F?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Error message when trying to search

    Thank you! I have never really used a forum, so I may be a little lost I am just very close to pulling out my hair with this issue.

    Yes, I am using ctrl+f then searching within the alloted cells, but still coming back with that error for every sheet/every criteria I try to use.

    Thanks!
    kelly

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Error message when trying to search

    When you CTRL F, click the Otions button, and change the "Look in" part from "formula" to "value" or vise versa, see if that helps?

    You did say that you know that what you are looking for exists? Are there any extra spaces etc? test that its the same with =exatct() or just =this=that

  5. #5
    Registered User
    Join Date
    11-27-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Error message when trying to search

    Yes, I have tried all the different options and searched even for the first letter of what I was looking for, searched with a wildcard in front of it and still getting the same error message. Not sure if there's a setting somewhere that limits the option to search, or if someone has changed something in my spreadsheet. Hope that makes sense....

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Error message when trying to search

    can you upload a small sample?

  7. #7
    Registered User
    Join Date
    07-19-2016
    Location
    Guatemala
    MS-Off Ver
    2013
    Posts
    1

    Re: Error message when trying to search

    This happened to me after I tried to modify a pivot table, when I opened the Value Field Settings and then I tried to change the Number format suddenly the dialog box desapear in front of my eyes, I think ok, I will start ageing however Excel didn't works because when I clicked the mouset button only a buzz sound I got and Excel was didn't do nothing, then a friend kill the task after that I start Excel again since that moment I tried to use CTRL+F and put a name that appear in 5 cells of my sheet and I need to put a different colour for diferent names using CTRL+F function, however all the time Excel gives me the message: Microsoft Excel ! We couldn't find what you were looking for. Click Options for more ways to search. AND THE PUSHBUTTON "OK".

    I copied the data and paste as value in another workbook and it didn't work. Then I tried with another workbooks and data sets, it didn't work anymore with any data, I need to reinstall my office 2013?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. An error message on open - a totally blank VBA message box
    By Mr_Tigas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2013, 11:29 AM
  2. [SOLVED] eliminating error message and search procedure
    By jamesjessie117 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2012, 07:28 PM
  3. Error message when doing search on Forum
    By jaslake in forum Excel General
    Replies: 4
    Last Post: 06-22-2009, 12:04 AM
  4. replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1