Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
What characteristics are required in the source data to create a PivotTable?
A list or table with values in it
A contiguous data range with headers
The data must be housed in an Excel table or covered by a named range
How do you remove an item from a PivotTable?
Drag it back from the Pivot fields into the field well
Delete it from the source data, then refresh the PivotTable
Right click the item in the field list and choose Remove
If you change something in your source data…
The PivotTable will update automatically.
Then you must manually refresh your PivotTable in order to see the change show up there.
You must close your workbook and re-open it to get the PivotTable to update.