Excel files generated through Excel Integration are protected such that users are only able to update single cells. We would like to have this protection modified to allow for mass updates (ie Find and Replace). Lack of this ability negates the value of exporting the data and the user is just as well off working within DSP updating one record at a time.
Find and Replace are supported already in the Excel Integration. The issue occurs if you try to replace a value that is found in the header columns that are locked to prevent modification. If you highlight the entire data segment, excluding the column headings you will be able to perform a full find and replace. Obviously this can cause issues with drop down lists, etc, so please verify the contents after running a replace.