Im having problems with the Replace menu command on an unprotected workbook
in Excel 2000. Ive set up one of the worksheets whereby Ive made the cells
refer to the raw data on another tab in the workbook, that way I only grab
the data I want. Using the Find command (Ctl-F), it finds the data on this
worksheet. However, if I try and use the Replace command to find data on
this sheet, it says the data cant be found (even though I can see it).

Example: in cell K2 of this worksheet I have the formula: =import!AD1. The
result displays the name of a company. Using Ctl-F, finds the occurrences of
this company. However, when using Replace (Ctl-H) to find this name, Excel
says that it cant find it. Is this because what is displayed is simply the
result of a formula telling it to look on another sheet and the Replace only
sees the formula, not its result? I know that when using the Find command,
I need to select Look in Values to find the company name, but when I
immediately click Replace (either from the Find box or directly by type
Ctl-H), that option isnt there. The €œFind entire cells only€� checkbox is
not checked. Whats wrong here?