You create an Excel workbook named SalesResults.xIsx. 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 SalesResult.xIsx 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. Save the workbook as an Excel Binary Workbook (.xlsb)
C. From Query Editor, open the Data Source and delete the credentials
D. Run the Document Inspector
