Hi,

I set up a data query via:

Data > Get External Data > From Other Sources > From Microsoft Query

When I set this up, I opted to refresh the data myself. I now wish to alter this to update the query everytime the document is opened.

Does anybody know how I can change this?

Thanks in advance