Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-21-2015, 08:49 AM
Pstloui Pstloui is offline Excel 2010 Find NOT Working Windows 7 32bit Excel 2010 Find NOT Working Office 2010 32bit
Novice
Excel 2010 Find NOT Working
 
Join Date: Apr 2015
Posts: 4
Pstloui is on a distinguished road
Default Excel 2010 Find NOT Working

Default Find Function Not Working - Solution


Issue where Excel find function stopped working correctly.

All, I have searched MSOfficeForums as well as other sites for a solution to this issue. When I noticed the sporadic problem occur, the only solution was to save, exit, re-open. Then, Find would work for a short while, then stop. Yes, I tried all of the suggestions, such as look in values, match case, match entire cell contents, but no luck.

Finally, I dropped the entire spreadsheet into Notepad and pasted back into Excel. Now Find works properly. The data was generated from a mainframe ASCII text file (yes ASCII, through SAS), then imported into Excel. This may be part of the problem, I don't know. Anyway, this seems to be the ONLY solution.

Also, quick note. I had used cell colors to visually delineate certain column groups. After pasting back in from Notepad, most of the cells lost coloring but some of the colored cells remained. I suspect issue may have to do will cell colors? Sounds odd, I know, but I suspect this may be part of the issue
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 Find NOT Working Find and Replace is not working Brigitte Word 7 06-15-2021 05:10 PM
Excel 2010 Find NOT Working Why is this Find string not working TechEd Word VBA 5 07-05-2014 08:12 PM
Find/Replace is not working - Excel 2010 fieldhaven Excel 2 02-19-2014 08:30 AM
Excel 2010 Find NOT Working Find and Replace not working alance Word 2 01-24-2014 02:11 AM
Excel 2010 drag-and-drop enabled but not working BobBridges Excel 1 05-28-2013 09:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 AM.


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