How to Call Pivot Table Macro from a User macro and pass parameters to Pivot Table Macro

mayank agarwal_nq8lfy

I want to create a user macro which automates the work of Pivot Table with fixed parameters.

Andrey Khaneev _StiltSoft_

Hello Mayank,

Try the following:

• Create a new page.
• Add Pivot Table macro with a dummy table that have expected columns.
• Set  Pivot Table macro as you need.
• Save the page.
• Open window with page storage format. You can view the Confluence storage format for a given page by choosing ... > View Storage Format.
• Copy this storage format, remove the dummy table and use it inside your user macro.