Datawatch Global Support reply....
Upon further investigation of this issue, importing password-protected Excel files is not a feature of Monarch. We are afraid that this issue is a bug, thus escalated to our Development Team for future enhancement.
We will contact you as soon as we figure out a fix for this. Thank you for your patience.