How to create multiple pivot tables for multiple excel files

How to create multiple pivot tables for multiple sheets at a time.
There are 4 excel files, 6 pivot tables should be created for them.How to do that

@anjani_priya

You can use create pivot table activity…or use vba…what ever is the way it would do one after the other only

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.