Refreshing a Query

I am trying to connect to a query in my workbook that retrieves data from an online MySQL database. I have a button that is linked to a VBA macro that refreshes the database in the worksheet when clicked on. The problem is, when I compile the workbook and it transforms into a .exe file, this button no longer operates.

I’m not sure which part of the settings is responsible for blocking the ability to refresh queries, but I’d appreciate if anyone knew.

Reponded by email.