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 PivotChart.

You plane to share SalesResults.slsx 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 . Modify the source of the query.
B . From Query Editor, open the Data Source Setting and delete the credentials.
C . Run the Document inspector.
D . Save the workbook as an Excel Binary Workbook (xlsx)

View Answer

Answer: B