We tried to upload the new employee upload file using the template you provided in your system several times but were not successful. We have already make sure the format are as stated in the notes.
We suspect it was due to the compatible Excel version of the file. We saved the files in Microsoft Excel 97-2003 Worksheet. However, the workbook contains formatting that is not supported by this file format. The dropdown disappeared after we saved the files. For your information, we are using Excel 2016 version and above.
We are unable to upload the templates for quite some time and we need to add the new employee details manually. This really consumed too much of our time.
Your kind assistance is highly appreciated.