Can I use an Excel Data Source with a Password?

No. If you are unable to remove the password, the only option is to have the file open in Excel while you are using it in PIESCentral.