Refresh Excel Data Connections Query

Open your excel using Excel Application Scope;
Inside the scope use an Attach Window to your Excel.
Use a Send Hot Key with Ctrl+Alt+F5 values.

I just answered a similar question here (screenshots available):

1 Like