About Ad Hoc Functions

Ad hoc functions perform ad hoc operations such as zooming, retrieving and submitting data, and pivoting.

• HypPerformAdhocOnForm

• HypRetrieve

• HypRetrieveRange

• HypRetrieveNameRange

• HypCreateRangeGrid

• HypGetNameRangeList

• HypRetrieveAllWorkbooks

• HypExecuteQuery

• HypSubmitData

• HypSubmitSelectedRangeWithoutRefresh

• HypSubmitSelectedDataCells

• HypPivot

• HypPivotToGrid

• HypPivotToPOV

• HypKeepOnly

• HypRemoveOnly

• HypZoomIn

• HypZoomOut