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.