You created a PivotTable and changed some values in the dataset from which the PivotTable was created. How does this affect the$$ PivotTable? Question content area bottom Part $1$ A$.$ Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. B$.$ The PivotTable is deleted from the workbook because it is not$$ up$-$to$-$date. C$.$ You must create a new PivotTable if you want updated results in a PivotTable. D$.$ The PivotTable is updated automatically when you make changes to the dataset.