<Pivot table>.AxisXY (Function) Allows you to: Specify the row and column headers displayed in a Pivot Table control. Find out the row and column headers displayed in a Pivot Table control. <Pivot table>.CalculateAll (function) Entirely calculates or recalculates a Pivot Table control. <Pivot Table>.CalculateAllAsynchronous (Function) Entirely calculates or recalculates a Pivot Table control, without blocking the application. <Pivot table>.CalculateUpdate (Function) Updates some of the data found in a Pivot Table control from a given date. <Pivot Table>.CalculateUpdateAsynchronous (Function) Updates some of the data found in a Pivot Table control from a given date without blocking the application. <Pivot table>.Collapse (Function) Collapses the data found in a Pivot Table control according to a row header or to a column header. <Pivot table>.CollapseAll (Function) Collapses all row and/or column headers in a Pivot Table control. <Pivot table>.Expand (Function) Expands the data found in a Pivot Table control according to a row header or to a column header. <Pivot table>.ExpandAll (Function) Expands all row and/or column headers in a Pivot Table control. <Pivot table>.Filter (Function) Enables or disables a filter on a Pivot Table control. <Pivot table>.HeaderValue (Function) Returns the value displayed in a header of Pivot Table control. <Pivot table>.InfoXY (Function) Returns the values of headers corresponding to a position in a Pivot Table control in pixels. <Pivot table>.ListPositionHeader (Function) Returns all values associated with a row or column header in a Pivot Table control. <Pivot table>.Load (Function) Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). <Pivot table>.Save (Function) Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). <Pivot table>.Select (Function) Allows you to find out the position of selected cells and to select cells in a Pivot Table control. <Pivot table>.SelectCount (Function) Returns the number of selected cells in a Pivot Table control. <Pivot table>.ToExcel (Function) Creates an Excel file with data from a Pivot Table control. Constants for managing Pivot Table controls The following constants are used by the functions that manage Pivot Table controls Functions for managing Pivot Table controls (prefix syntax) Functions for managing Pivot Table controls (prefix syntax) Pivot Table control functions Pivot Table control functions PVTAxisXY (Function) Used to: Specify the row and column headers displayed in a Pivot Table control. Find out the row and column headers displayed in a Pivot Table control. PVTCalculateAll (Function) Entirely calculates or recalculates a Pivot Table control. PVTCalculateAllAsynchronous (Function) Entirely calculates or recalculates a Pivot Table control, without blocking the application. PVTCalculateUpdate (Function) Updates some of the data found in a Pivot Table control from a given date. PVTCalculateUpdateAsynchronous (Function) Updates some of the data found in a Pivot Table control from a given date without blocking the application. PVTCollapse (Function) Collapses the data found in a Pivot Table control according to a row header or to a column header. PVTCollapseAll (Function) Collapses all row and/or column headers in a Pivot Table control. PVTCompareDateRange (Function) Calculates and displays a date range comparison in a Pivot Table control. PVTExpand (Function) Expands the data found in a Pivot Table control according to a row header or to a column header. PVTExpandAll (Function) Expands all row and/or column headers in a Pivot Table control. PVTFilter (Function) Enables or disables a filter on a Pivot Table control. PVTHeaderValue (Function) Returns the value displayed in a header of Pivot Table control. PVTInfoXY (Function) Returns the values of headers corresponding to a position in a Pivot Table control in pixels. PVTListPositionHeader (Function) Returns all values associated with a row or column header in a Pivot Table control. PVTLoad (Function) Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). pvtPosition (Type of variable) The pvtPosition type is used to handle a cell of a Pivot Table control. PVTSave (Function) Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). PVTSelect (Function) Allows you to find out the position of selected cells and to select cells in a Pivot Table control. PVTSelectCount (Function) Returns the number of selected cells in a Pivot Table control. PVTToExcel (Function) Creates an Excel file with data from a Pivot Table control. WLanguage procedure called by PVTCalculateAllAsynchronous WLanguage procedure ("callback") called by PVTCalculateAllAsynchronous once all the data of a Pivot Table control has been calculated. WLanguage procedure called by PVTCalculateUpdateAsynchronous WLanguage procedure ("callback") called by PVTCalculateUpdateAsynchronous once all the data of a Pivot Table control has been calculated.