There is no way to currently automate the refresh of queries via report
builder using macros. I have tried quite a few different ways and I am
unable to make it work. If someone has a solution out there please pass
it along. Macros work perfectly with the excel client.
The newest version of excel for the mac imitates the PC version, and for
the first time I can actually us excel in the mac environment. I used to
have to run everything through vmware in order to utilize adavnced excel
functions. I am suggesting you get the add-ins for the excel client and
report builder created for the 2010 version of excel for the mac to make
my life easier.