An analyst has a pivot table summarizing data from a source range of 'Sheet1'!A1:D500. If they add 100 new rows of data to the bottom of the source sheet (in rows 501-600), what must they do to include this new data in the pivot table's analysis?
-
A
Use a Slicer to add the new data.
-
B
The pivot table will automatically detect and include the new rows.
-
C
Delete the pivot table and create a new one.
-
D
Edit the pivot table and update the source data range to 'Sheet1'!A1:D600.