To see what is going on, I do not need the real data. I need the SAMPLE to reproduce the behavior.
Other than that, try to save the file in Excel Version 3 first.
Also, try to copy the data into the separate Excel sheet with PASTE SPECIAL option, VALUE only, and import from there.

>Sorry, proprietary data. I'm not sure of the Excel version off-hand, but the spreadsheet does have formulas and macros.
>
>>The solution may depend on what is the Excel file version, whether there are links, formulas or custom formatting, etc.
>>If you wish, send the Excel sample file to me. I will see what can be done.