Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2016, 09:16 AM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Default Find does not work

Sometimes I can find a cell using find, other times not. Although this is used primarily for cells formatted for text, the same is true for number. It appears that for some sheets find will never work, and on others it always work. So do I need to do for find to be able to work?
Reply With Quote
  #2  
Old 03-05-2016, 10:48 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Find does not work Windows 7 64bit Find does not work Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

When you say "doesn't work", what do you mean? Perhaps post a sample sheet showing where it goes wrong.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-05-2016, 04:42 PM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Default

I don't know how to post a sample sheet. I do have two jpgs. But its very simple: on sheets in which find works, "find all" returns a list of cells containing the designated text string. When it isn't, "find all" returns the message "Microsoft office cannot find the data you're searching for", even though it too is in multiple cells, in sheets formatted exactly the same way as those for which find is working.
Reply With Quote
  #4  
Old 03-05-2016, 10:51 PM
jolivanes jolivanes is offline Find does not work Windows XP Find does not work Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default

Quote:
I don't know how to post a sample sheet.
If you take some time and go to FAQ, you'll find this:
How do I attach a file to a post?

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

What files types can I use? How large can attachments be?

In the attachment window you will find a list of the allowed file types and their maximum sizes. Files that are larger than these sizes will be rejected. There may also be an overall quota limit to the number of attachments you can post to the board.

How do I add an image to a post?

If you have uploaded an image as an attachment, you can click the arrow next to the 'Attachment Icon' and select it from the list. This will be inserted into your post and can be located where you want it displayed.

To include an image that is not uploaded as an attachment and is located on another website, you can do so by copying the full URL to the image, (not the page on which the image is located), and either pressing the 'Insert Image' icon or by typing [img] before the URL and [/img] after it, ensuring that you do not have any spaces before or after the URL of the image. You can insert pictures from your albums (?) in this way too.
Reply With Quote
  #5  
Old 03-06-2016, 04:27 PM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Talking Actual problem sheet and screen shots

As you can tell from the screen shots, it's the OF excel sheet that does not work and does not return any of the expected text strings. The SP sheet returns a long list of the expected string.

I hope having the actual sheets will allow you to troubleshoot the problem.

Thanks!
Attached Images
File Type: png excel1.png (96.4 KB, 24 views)
File Type: png excel2.png (110.6 KB, 24 views)
Attached Files
File Type: xlsx OF 3yr stats.xlsx (72.1 KB, 15 views)
File Type: xlsx SP 3yr stats.xlsx (84.0 KB, 11 views)
Reply With Quote
  #6  
Old 03-07-2016, 01:17 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Find does not work Windows 7 64bit Find does not work Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Which string are you searching for? The images are unreadable
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #7  
Old 03-07-2016, 12:10 PM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Default Find not working -- new screenshots

Perhaps these will help, but as I apparently haven't made clear, the information for which I am using "find all" could be the complete or partial contents of a cell; text or number. There is simply no "find all" that returns any results for any of the many items that appear on the sheet. On the SP shot, you can see the long list of results for NYM, whereas on the OF sheet I get no results for ARI, despite the fact that two cells containing it are visible. You should already have the actual sheets from the previous reply.
Attached Images
File Type: png SP.png (99.2 KB, 21 views)
File Type: png OF.png (63.7 KB, 21 views)
Reply With Quote
  #8  
Old 03-07-2016, 12:29 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Find does not work Windows 7 64bit Find does not work Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Works perfectly for me on both sheets
Anything special in the search options ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #9  
Old 03-07-2016, 01:44 PM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Smile Works for me now, too

Thank God for screengrabs, otherwise this would be just like when you bring your car to the mechanic because it's making a noise that it stops making as soon as you pull up to the garage.

There was nothing special about the find all, as you can see from the one that works. However, I tried what's worked in the past, which was to copy the entire sheet and past it into a new sheet, and that appears to have alleviated the issue.

You will hear from me again if it happens again. Otherwise, cheers!
Reply With Quote
  #10  
Old 03-07-2016, 01:52 PM
gebobs gebobs is offline Find does not work Windows 7 64bit Find does not work Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Try clicking the options button on the find dialog. See if "match entire cell contents" is checked. If I know something is there and Excel can't "find" it, that is usually the case.
Reply With Quote
  #11  
Old 03-07-2016, 02:17 PM
jdkoerner jdkoerner is offline Find does not work Windows 7 64bit Find does not work Office 2007
Novice
Find does not work
 
Join Date: Feb 2015
Posts: 25
jdkoerner is on a distinguished road
Default

Did that. Answer isn't there.
Reply With Quote
  #12  
Old 03-08-2016, 03:20 AM
Debaser's Avatar
Debaser Debaser is offline Find does not work Windows 7 64bit Find does not work Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Also bear in mind that if you have more than one cell selected, Excel will only search that selection.
Reply With Quote
  #13  
Old 03-08-2016, 06:22 AM
gebobs gebobs is offline Find does not work Windows 7 64bit Find does not work Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Debaser View Post
Also bear in mind that if you have more than one cell selected, Excel will only search that selection.
Ahhhh...that's it exactly. The OP has line 1137 selected in his OF sheet.
Reply With Quote
Reply

Tags
find, find & replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find does not work Find and Replace doesn't work. Bop70 Word 3 02-04-2015 11:45 AM
Find and replace No longer work TJH Word 3 03-25-2014 11:33 PM
Find does not work work of labor vs work of excavator ketanco Project 1 02-11-2014 08:53 AM
Where we can find a Word document (docx file) that contains professional work inside? Jamal NUMAN Word 0 06-26-2011 09:57 AM
Outlook- "Type A Contact To Find" Doesn't Work jill5545 Outlook 0 11-14-2010 08:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft