What should you do?

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a PivotTable and a PivotChart.

You plan to share SalesResults.xlsx to several users outside of your organization.

You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed.

What should you do?
A . Run the Document Inspector.
B . Save the workbook as an Excel Binary Workbook (.xlsb).
C . From Query Editor, open the Data Source Settings and delete the credentials.
D . Modify the source of the query.

View Answer

Answer: C