I have a Domo plugin in Excel to connect to our Domo instance and pull data to refresh an Excel document that generates a Pivot table since there are limitations in Domo that prevent us from displaying the data in that particular format.
I can use the plugin without any problems, but I cannot automate it using an Excel macro. Does anybody know how to execute the plugin in an automated way? I would need to have a macro so the business users can use it to refresh the Pivot table. I don't want them to do it manually as they are not familiar with Domo, datasets, etc.
Thank you.