CalculatedMember.Dynamic property (Excel)

Returns whether the specified named set is recalculated with every update. Read-only Boolean.

Syntax

expression.Dynamic

expression A variable that returns a CalculatedMember object.

Return value

Boolean

Remarks

True if the named set is recalculated with every update; otherwise, False.

The value of this property corresponds to the setting of the Recalculate set with every update check box in the New/Modify Set dialog box that is available when a named set is created or edited.

To create a new named set from data in a PivotTable based on an OLAP data source, choose the PivotTable, choose Field, Items, & Sets on the PivotTable Tools Options tab on the ribbon, choose Manage Sets, choose New in the Set Manager dialog box, and then choose Create Set using MDX.

This will display the New Set dialog box, which contains the Recalculate set with every update check box. Similarly, if you select an existing named set in the Set Manager dialog box, and then choose Edit, the Modify Set dialog box is displayed.

This property, along with the DisplayFolder and HierarchizeDistinct properties, can only be read for named sets (which are represented by CalculatedMember objects where the Type property equals xlCalculatedSet).

These properties cannot be read for calculated members or measures (which are represented by CalculatedMember objects where the Type property equals xlCalculatedMember). If you attempt to read these properties for calculated members or measures, a run-time error is raised.

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.