Updates the data for a pivot table. Use this activity when the source data for a pivot table has changed. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.
- Pivot table to refresh - Click Plus on the right side of the field, then select the Excel file and the name of the pivot table. or select Indicate in Excel to open the file and indicate a cell from the pivot table. Alternatively, you can select Custom Input to enter the pivot table name manually, or Open in Advanced Editor to enter a VB expression.
- DisplayName - The name displayed for the activity in the Designer panel.
- See Pivot table to refresh in the body of the activity.
- Private - If selected, the data used in the activity is not logged by StudioX.