 <p>Erm, i think i found a solution here, the file i downloaded from the internet is not password protected, it is just in protected mode.</p> <p>so the answer to this is basically to disable the protected mode in excel. thanks for the answer anyway. @Hao</p>