-----Create Pivot Table in Excel----

I have a problem with “create Pivot Table”.

When I tried to create a pivot table, it always came an error that “RemoteException wrapping System.Runtime.InteropServices.COMException: Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)”

Could anyone point out my mistake or how to solve this issue?
Also please find the attachment of excel for reference.Pivot-Example.xlsx (10.3 KB)

hi @crm_new

can you pls tell the values for the highlighted fields?
image

Regards
Ashley

Below are the fields

Rows = Agent/Owner
Column = State
Value = State

Hi @crm_new
I have created a macro for your test case hope it might help you
please give the relevent pathof the excel file on which you want to apply the pivot on.

Pivot.zip (13.7 KB)

Hello,

Getting Error… Can you help on this

image

Enable the macros then try running the code

Thanks…

After enabling facing same issue. is there any alternate solution or i am missing any step

what version of msoffice are you using?

office 2007

https://www.techonthenet.com/excel/questions/developer_tab2007.php

Turn on the developer tab using this and then run the program

still not working after enabling developer tab.

image

image
you have to give the excel file path here and donot change the path of excel application scope

Ok… Is it possible to share Macro code with me?

i have shared the macro code its in the zip folder

Still Getting error