Microsoft
70-779 · Question #69
You have a workbook query that loads data from C:\Data\Users.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…
The correct answer is B. From Query Editor, modify the Source step. See the full explanation below for the reasoning.
Question
You have a workbook query that loads data from C:\Data\Users.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?
Options
- AFrom the Linked Table tab in Power Pivot, modify the Update Mode.
- BFrom Query Editor, modify the Source step.
- CFrom the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
- DFrom the Data tab in Excel click Connections, and then modify the properties of the connection.
How the community answered
(33 responses)- A9% (3)
- B82% (27)
- C6% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.