![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Brigitte | Word | 7 | 06-15-2021 05:10 PM |
![]() |
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 |
![]() |
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 |