createPivotTable(Range) Method

create a pivot table object one cell below TargetCell and insert a dummy cmd sql definition for the pivot-cache external query

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public static void createPivotTable(
	Range TargetCell
	)

TargetCell: Type: Range
the reference cell for the pivot table (will be the source cell for the DBSetQuery function)