Procedure PivotTableSaveState(page, tag, statesource)


With the procedure PivotTableSaveState you can save the state of a specific pivot table to either the developer or user state file.

            page,       ! (input) scalar string expression
            tag,        ! (input) scalar string expression
            statesource ! (input) scalar string expression



A string expression representing the name of the page that contains the pivot table.


A string expression representing the tag that identifies the pivot table.


A string expression representing the type of state to be saved. Possible values are:

  • DeveloperState: Save the specified state to the developer state file.

  • UserState: Save the specified state to the user state file.

Return Value

The procedure returns 1 on success. If it fails to save the state for the specified object, then the return value is 0 and CurrentErrorMessage will contain a proper error message.


  • When running in end-user mode, it is not possible to save a developer state.

  • You can specify a unique tag name for each page object on the Misc tab of the object properties dialog box.

  • The name of the state is specified by the Specific State Name property on the General tab of the pivot table properties dialog box.

  • This procedure will only save the state when the Save Layout/State - By Developer property (or Save Layout/State - By End User when running in end-user mode) on the general tab of the pivot table properties dialog box, has been set to a value other than No.

See also

  • The Pivot Table example that comes with the AIMMS installation includes a library that uses this new function. It includes a right-mouse menu that can be assigned to a Pivot Table, after which the user can save, load, or delete states for that Pivot Table. You can include this library in your own project as well.

  • The functions PivotTableDeleteState, PivotTableReloadState.