VBA - Refresh Power Query gives error with Microsoft.Mashup.OleDb.1

[jmattus]

I have a simple Power Query that is trying to be refreshed. It accesses a web table. No credentials are needed. The code works fine on my machine. However, when another user tries the exact same file/program on a different machine, they get this error:

The 'Microsoft.Mashup.OleDb.1' provider is not registered on the local machine.

Here is the code I am using:

wb.Connections("Query - PickedPlansTblQry").OLEDBConnection.Refresh

I am using Excel 2016. The other person is using 2013. Suggestions?

Thanks for any help.

J

 

[jmattus]

So I found the answer. The issue was that Power Query is not automatically a part of Excel 2013 and it needed to be installed. After that, viola! it works.

Posted this answer for anyone else having the same issue.

J