I have a template excel file where I place datatable using Append range. After appending, I need to create a pivot table using the written data, in the same sheet. I need it to be done in the background, without opening Excel. Please advise! Thank you!

Hi @Michael_de_Borja I’ll suggest you to record macro in excel with creating Pivot table and use Invoke VBA activity to invoke that vba script. For that follow these steps :- Record macro with creating Pivot table, Save that Macro in a text file with a .txt extension. call the text file in invok…

Creating Pivot Table in the background

Help

Michael_de_Borja (Michael de Borja) July 2, 2019, 10:10am 4

Thanks!

Topic		Replies	Views
Create a pivot table Help	9	6027	August 20, 2020
Creation of Pivot Table Help excel , activities , question	9	2677	March 3, 2020
How to create a pivot table from a data table Help excel	8	3311	February 13, 2020
How can i create pivot table without macro Forum question	2	791	November 25, 2021
Help With Pivot table Activities excel , activities , question	1	493	January 26, 2023

Creating Pivot Table in the background

Related topics