PROBLEM:

Received the following error with importing a scenario into the ESOPT tool:

 



This happened with both the ESOPT Startup.xls & Default.xls. This error is happening on 3 laptops with all the users experiencing this issue based in Canada.


CAUSE:

Due to the error being on laptops in Canada, troubleshooting lead to a date format being the cause. The date format that was being used on the Dell machines in Canada was DD/MM/YYY, unlike the US date format of MM/DD/YYYY.


RESOLUTION:

Changing the date format in the Windows control panel from DD/MM/YYYY to MM/DD/YYYY, the scenarios imported successfully.