R
Renegade
I have approximately 10 names wrapping in an Excel cell throughout a
spreadsheet. Some of the names are misspelled or inverted. When I attempt
to find and replace a name, Excel gives me an error message that states: "MS
excel cannot find any data to replace. Check if your seach formatting and
criteria are defined correctly. If you are sure that matching data exists in
this workbook, it may be on a protected sheet. Excel cannot replace data on
a protected worksheet." These names were copied into Excel from another
application (iPro). Anyone have any ideas how to get around this situation?
Thanks in advance for any assistance that can provided.
spreadsheet. Some of the names are misspelled or inverted. When I attempt
to find and replace a name, Excel gives me an error message that states: "MS
excel cannot find any data to replace. Check if your seach formatting and
criteria are defined correctly. If you are sure that matching data exists in
this workbook, it may be on a protected sheet. Excel cannot replace data on
a protected worksheet." These names were copied into Excel from another
application (iPro). Anyone have any ideas how to get around this situation?
Thanks in advance for any assistance that can provided.