You have an Excel workbook query that loads data to a worksheet and the data model.
You need to ensure that the data is refreshed whenever you open the workbook.
What should you do?
A. From the File tab, click Options, and then modify the General options
B. From the Power Pivot model, modify the Table Behavior setting
C. From the File tab, click Options, and then modify the Data options
D. Run the Data tab, click Queries & Connections, and then edit the properties of the query
D is the correct answer.
D is correct answer.
In Excel click Data tab, in the Queries & Connections section select any active Queries & Connections. Pick the connection you wish to modify. Right click and select Properties. There you can select the Checkbox to refresh when opened.
None of them looks corret to me…
PivotTable Tools -> Options -> data-> enable Refresh the data when open the file.