Back to lesson
1. What characteristics are required in the source data to create a PivotTable?
A contiguous data range with headers
The data must be housed in an Excel table or covered by a named range
A list or table with values in it
2. How do you remove an item from a PivotTable?
Delete it from the source data, then refresh the PivotTable
Drag it back from the Pivot fields into the field well
Right click the item in the field list and choose Remove
3. If you change something in your source data…
Then you must manually refresh your PivotTable in order to see the change show up there.
The PivotTable will update automatically.
You must close your workbook and re-open it to get the PivotTable to update.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement