Show or hide drop areas
When the drop areas are hidden and the PivotTable list does not have a field in the row, column, data, or filter area, you can't drag fields to these areas.
- On the toolbar in the PivotTable list, click Commands and Options
, and then click the Behavior tab. -
Select or clear the Drop areas check box.
Note You will not see the drop areas if the PivotTable list is not bound to a data source.