PivotCell.ServerActions property (Excel)

  • Article

Represents a collection of actions consisting of OLAP-defined actions that can be executed. The actions are specific to PivotTables existing at a worksheet-level. Read-only.

Syntax

expression.ServerActions

expression A variable that represents a PivotCell object.

Remarks

A server action is an optional feature that an OLAP cube administrator can define on a server that uses a cube member or measure as a parameter into a query to obtain details in the cube.

Property value

ACTIONS

Example

The following code segment executes a server action against a series in a PivotChart.

ActiveSheet.ChartObjects("Chart 1").Chart.PivotLayout.PivotTable.PivotColumnAxis.PivotLines(index of line ).PivotLineCells(index of cells ).ServerAction("OLAP Action name" ).Execute

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.