PivotTable Option – Data Tab
MS-EXCEL-57-PivotTable Option - Data Tab - PivotTable without Source Data - Refresh Automatically
learn about the Data Tab of PivotTable Options, Save Source data with File, Use of Enable show details, Refresh data when Opening the file