An export to file activity is created in automation.
The exported data will be saved in an existing Excel file that contains a pivot table.
The Excel file contains two sheets:
- Sheet DATA: It contains the data to be exported.
- Sheet B: It contains a pivot table created from Sheet DATA. The option "Add this data to the Data Model" has been selected, so the pivot table will be refreshed automatically
When the export completes, the data is exported on Sheet DATA but the pivot table of Sheet B disappears.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.