Analyzing and Visualizing Data with Microsoft Excel — Question 25

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?

Answer options

• A. From Query Editor, modify the Source step
• B. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins
• C. From the Linked Table tab in Power Pivot, modify the Update Mode
• D. From the Data tab in Excel, click Connections, and then modify the properties of the connection

Correct answer: D

Explanation

The correct answer is D because modifying the properties of the connection will update the file path to the new location on the shared folder, allowing for data refresh. Options A, B, and C do not address the need to change the data source path for refreshing the workbook query.