Something doesn’t seem right to you when you’re looking at the $74.15 for the Korean Beef Satays shown in the PivotTable below. How would you go about inspecting the records that contributed to this value?

;

Answer 1

Go back to the source data table and filter the records consistently to show only Appetizers for the Category column, Korean Beef Satays for the Item Name column and 2 for the Week column

Answer 2

Double-click the cell that contains the $74.15 value (highlighted in yellow)

Answer 3

It is not possible to do this easily

Answer 4

Don’t know

Answer 5

You couldn’t

Answer 6

Remove all row, column and report filters, remove all but one field from the values area of the PivotTable, and double-click that value cell

Answer 7

Right-click any value in the PivotTable and choose “Show Details”

Answer 8

Don’t know

Answer 9

Delete the original data table

Answer 10

Turn on Excel’s worksheet protection feature to protect the PivotTable

Answer 11

Go to PivotTable Options > Data > uncheck the “Enable Show Details” checkbox

Answer 12

Don’t know

Something doesn’t seem right to you when you’re looking at the $74.15 for the Korean Beef Satays shown in the PivotTable below. How would you go about inspecting the records that contributed to this value?

If someone sent you a PivotTable, but deleted the original data source, how could you go about re-creating that data source?

The Show Details feature is very useful, but easy to accidentally trigger when using a PivotTable. If you wanted to prevent your users from accidentally drilling in to a data set and littering the workbook with extra worksheets, how would you do it?