You have a workbook query that loads data from C:DataUsers.xlsx.
You move Users.xlsx to a shared folder on the network.
You need to ensure that you can refresh the data from Users.xlsx.
What should you do?
A . From the Linked Table tab in Power Pivot, modify the Update Mode.
B . From Query Editor, modify the Source step.
C . From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
D . From the Data tab in Excel click Connections, and then modify the properties of the connection.
Answer: A