1

I am using Excel 2010 with PowerPivot. I am trying to go to the Query Editor. When I click on Table Properties, I get a password prompt:

enter image description here

The problem is that I don't know the password and when I press OK, I get a User name or password is invalid error:

enter image description here

I've never had this issue before. The problem started to occur when performing those steps via different computers than the one the spreadsheet was initially created with. Unfortunately I can't open the spreadsheet with the original computer as it went missing.

Is there a way to bypass the Data Source Credentials (I've never had to enter any before)?

1

OK, problem wasn't related to credentials but to data path. After acknowledging the error message, you get another error at the bottom of the table properties window:

enter image description here

That's what made me realize it could be related to data paths. When clicking on Existing Connections I realized files were mapped under a different drive. Creating that drive on the new computer fixed the issue.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.