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.

1. On the toolbar in the PivotTable list, click Commands and Options , and then click the Behavior tab.

2. 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.