Not sure how this happened, but could use some help.

I am trying do an EDIT REPLACE in my excel workbook, but in the LOOK IN:
drop down box it only has "Formula" - The "Values" & "Comments" options are
NOT available to pick from. Subsequently, I am not able to do a "replace" in
any of my workbooks.

Any idea what happened to cause this and how to fix it?

While I'm here, I have another question to ask..
Is is possible to change the FIND & REPLACE "Look In:" default to "values"
instead of "formula" in the FIND and REPLACE feature.