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.
I have managed to upload Employee records using excel except for the effective dates. The effective dates or rather all date columns have been updated as 1st of May.