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

Help
1

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)

2

hi @crm_new

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

Regards
Ashley

3

Below are the fields

Rows = Agent/Owner
Column = State
Value = State

4

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)

5

Hello,

Getting Error… Can you help on this

image

6

Enable the macros then try running the code

7

Thanks…

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

image
image815×293 13.5 KB

8

what version of msoffice are you using?

9

office 2007

10

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

11

still not working after enabling developer tab.

image

12

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

13

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

14

i have shared the macro code its in the zip folder

15

Still Getting error

image
image1360×525 54.9 KB

image
image1209×534 43.8 KB