You export a Microsoft Excel workbook from Dynamics 365. The workbook contains 10,000 rows of data. You email the workbook and a description of the data to another user.
The user reports that they can only see 500 rows of data.
You need to determine why the user cannot view all the data.
Why is the user unable view all available data?
A. You exported a static worksheet. The user does not have the appropriate security role in Dynamics 365 to see all records.
B. You exported a PivotTable worksheet. The user does not have the appropriate security role in Dynamics 365 to see all records.
C. You created a chart in Dynamics 365 Customer Engagement and exported the chart.
D. You ran a report in Dynamics 365 Customer Engagement and then saved the report as an Excel file.
Alex+1
Correct Answer: B
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-pivottable
When you export to a dynamic worksheet or _PivotTable_, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view.