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.