Show All

Automatically show items or details in PivotTable view

1. Open a datasheet or form in PivotTable view.
2. On the PivotTable toolbar, click Properties , and then click the Behavior tab.
3. Do one or both of the following:

   Automatically show items

   • Set the Expand items by default option to Always.

   Automatically show details

   • Set the Expand details by default option to Always.

Note  To hide all items, set the Expand items by default option to Never. To hide detail data for all items, set the Expand details by default option to Never.