Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 4th 21, 06:27 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2020
Posts: 2
Default Excerl 2002...FInd and Replace not working properly

I have some large worksheets in Excel 2002 and I often use Control-F (Find
and Replace) to locate items. Lately it has been working erratically, and
more often than not produces this error message:

"Microsoft Excel cannot find the data you're searching for. Check your
search options, location, and formatting."

Closing and re-opening Excel isn't fixing this problem, it keeps
re-occurring.

Does anyone have an explanation for what triggers this, and a way I can get
Find and Replace working properly again.

John



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Choose format while Find & Replace not working Ghitorni Excel Discussion (Misc queries) 0 February 22nd 10 10:29 AM
Find and Replace function not working wt.pm Excel Discussion (Misc queries) 2 April 14th 09 05:16 PM
Excel 2002: Why Find and Replace not working? Mr. Low Excel Discussion (Misc queries) 6 January 6th 09 03:37 PM
How do I find and replace null values in Excel 2002 worksheets? Peter Excel Worksheet Functions 5 October 27th 06 04:53 AM
Replace function not working properly in Excel 2000 SP3 rgbytg Excel Worksheet Functions 5 November 11th 04 03:44 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017