Hey guys,
I wanna know how Pivot table can be created.
I’ve just created a pivot table manually.
And, I tried automating it with the activity, but getting errors. Test.xaml (5.6 KB)
I need some help here.
Thank you.
Hey guys,
I wanna know how Pivot table can be created.
I’ve just created a pivot table manually.
And, I tried automating it with the activity, but getting errors. Test.xaml (5.6 KB)
I need some help here.
Thank you.
Yea @sarathi125,
I’ve used that same activity.
Sometimes it works fine and creates a pivot table, but it’ll be in a different format and not as how I need and sometimes it’ll just throw an error.
Hi @NiranjanKN,
If the excel data is in form of excel this activity can be used for pivot table creation.
If not we can use invoke code to do so
Hi @NiranjanKN,
Kindly follow the link below,
Hey, @samir
I followed the steps:
But, I got this error.
May I know what needs to be changed in this Pivot.zip (25.3 KB)
Thank you.
Hi @NiranjanKN,
Firstly, Do check EntryMethodName (parameter of Invoke VBA activity), In your macro, the method name is Macro1, so mention the same at EntryMethodName parameter (“Macro1” instead of “Main”).
Secondly, don’t forget to check this checkbox below,
Steps: