Translations:Basic Excel/212/en
The default value for the 'Tabel/Rentang' box in the 'Buat PivotTable' dialog box will be the (contiguous) data range or table (if it was part of one) of the cell that was selected when the dialog box was launched. This entry can be changed, either by inserting a named range (in this case, we could use AIData2 or AIData3) or by choosing a new range.