What should you do?

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.

View Answer

Answer: A