Forum Discussion
Solved
vba microsoft.mashup.oledb.1 provider is not registered on the local machine
Hello, some moths ago the following vba script stop working: sub auto_open ActiveWorkbook.Connections("Query - Query1").Refresh end sub the error message is : microsoft.mashup.oled...
Hi Carlos,
May I recommend you to have the following changes:
1. Update auto_open as follow
sub auto_open
ActiveWorkbook.RefreshAll
end sub
2. Uncheck "Refresh this connection on Refresh All" property for all the queries you want to refresh by code (i.e. Query1, Query2 etc.)
This solution works for me.
Cheers,
Brian
I found a way that seems to enable my macro to work again, though im not sure why it works.
The method is:-
Go to the Queries connection and for the queries that had been setup, right-click and choose "properties" - under the refresh control , choose to tick the "Enable Fast Data Load" and untick the "Refresh this connection on Refresh All".
I had the same issue as well. I tried something similar to your solution above, and it worked. I have >150 queries so would be unfeasible to apply your solution to each. See my solution below
Go to Data -> Get Data -> Query Options
Tick "Fast Data Load"
when I did this and saved my workbook all the macros started working again!
hope this helps others as well.
