Constant | Description |
xlConsolidation | Multiple consolidation ranges |
xlDatabase | Microsoft Excel list or database |
xlExternal | Data from another application |
xlPivotTable | Same source as another PivotTable |
ActiveSheet.PivotTableWizard xlDatabase, Range("A1:C100")