This is usually caused by the Excel worksheet being in .XLS format instead of .XLSX

The user must convert the worksheet to the latest format for this to work or they can do the following....