When DataImport is used to create an Excel 5.0, 7.0 file and then the file is opened and saved in Excel 97 format, the file does not replace when the Replace option is chosen from the DataImport Translate option.
When used with the Excel 5.0, 7.0 file format, DataImport attempts to replace only the selected Worksheet, not the entire file. This causes problems if the file being replaced has been resaved in Excel 97 format. DataImport will appear to run the translation, but no data will be updated because DataImport doesn't understand Excel 97 file formats.
To resolve the problem, do not save spreadsheets that will be processed by DataImport into the Excel 97 format. Only save them into the Excel 5.0/7.0/95 format, so DataImport can accurately access and replace data in an Excel Worksheet.