Pivot table creation

[Sudha_RPA]

Hi All,

I  was trying to create a pivot table using excel vbo but i was getting error can anybody help with what is the input for it

Note : Attached pivot table input and error i got

Regards,

Rajsudhapriya

------------------------------
Sudha Priya
------------------------------

[Athiban_Mahamathi]

Hi Sudha,

The input field labeled "Workbook" expects a workbook name as its value. I can see that the current value mapped to this field is the file path of the workbook. Please update the value of the "Workbook" parameter to create the pivot table.

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

[Sudha_RPA]

Hi Athiban,

I have changed the workbook name but im getting new error

------------------------------
Sudha Priya
------------------------------

[harish.m · Accepted solution]

Hi Sudha Priya,

Pivot table is expecting  the column names as list

Check below threads

https://www.contextures.com/excelpivottableerrors.html#:~:text=The%20pivot%20table%20error%2C%20%22field,the%20source%20data%20is%20blank.

https://www.wallstreetmojo.com/pivot-table-field-name-is-not-valid/

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------