I tried to separate this step from the rest of the steps in Excel. I used a Use App/Browser activity, and set it up for the robot to click the “Refresh All” button to refresh the data connections. However, when the robot opens the file in Excel, none of the buttons in the ribbon are present to click!
Any idea why this would be the case?