LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
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

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


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 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 12:19 PM.

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

About Us

"It's about Microsoft Excel"