+ Reply to Thread
Results 1 to 3 of 3

Windows search finds data in spreadsheet that I cannot find when in Excel

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Windows search finds data in spreadsheet that I cannot find when in Excel

    At one time, there was a custom header in a spreadsheet with the word "Scarborough" in it. I edited the header and removed the word. I then used this file as a template file, and every spreadsheet that I create from this template continues to be found by Windows Explorer when I search for this word but nothing I am able to do in Excel searching seems to be able to find out where this word is actually stored.

    Are there any additional tools that I can use to locate where in my spreadsheet this word might exist?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Windows search finds data in spreadsheet that I cannot find when in Excel

    Use Find (Ctrl+F) and Click Options select Workbook under Within Dropdown and click Find Next Button.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Re: Windows search finds data in spreadsheet that I cannot find when in Excel

    I don't mean to be disrespectful, but I'm not so junior as to have not done that a dozen different ways. I appreciate that you might be trying to help, but I thought that by saying that "nothing I am able to do in Excel searching" would have indicated that.

    Unfortunately, the trouble is that the search term is far more embedded in the spreadsheet than the standard search tools are able to find. There are no hidden worksheets, no protected worksheets, and there's nothing in my VBA code or other visible areas where the term "Scarborough" can be found.

    If there's anyone that knows how to dig further into the spreadsheet, maybe with VBA, I would appreciate your help.

+ 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. Replies: 1
    Last Post: 05-16-2013, 12:50 AM
  2. Windows Excel Search
    By subhotech in forum Excel General
    Replies: 1
    Last Post: 10-08-2007, 10:18 PM
  3. Replies: 1
    Last Post: 06-15-2006, 09:15 PM
  4. to search for a string and affect data if it finds the string?
    By Shwaman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2006, 09:00 PM

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