Describes the source of a pivot cache's data when the source is a worksheet range or named range/table. Either ref + sheet identifies a cell range, or name identifies a defined name or table (with optional sheet for sheet-scoped names).
ref
sheet
name
Describes the source of a pivot cache's data when the source is a worksheet range or named range/table. Either
ref+sheetidentifies a cell range, ornameidentifies a defined name or table (with optionalsheetfor sheet-scoped names).