For the excel file to function seamlessly, macros need to unblocked, follow the given steps to unblock the same:
1. Close the template file.
2. Right click on the file and go to "Properties"
3. This will open another window, click "UNBLOCK" as shown below