thanks for taking the time shong,
at first i though you were talking about a newer version of Talend then the one i have installed.
but maybe i have come across a bit of a bug on the UI
when i add my Excel connection, it does not show the 'Don't validate the cells' on the Advanced Tab.
it seems that when create an Excel input from the repository something does not work correctly.
*BUT* if i drag an excel input from the pallete it shows option on the advanced tab.
after i clicked every possible thing on this component - it seems that if you click on the 'use excel 2007' the un-click it.
it resets the Advanced Tab and it then shows all options as expenceted.
please see screenshot..
i will test the Excel conversion and report back