If you don't have access to the password, you can click on the "Preview" option to open the password-protected MS Office file ...
You can link Google Sheets with Microsoft Excel by creating a web query in Excel. But this is only one-way integration which means that the changes made to Google Sheets will automatically be updated ...