topic RE: Pivot table creation in University Forum

Pivot table creation

Sudha_RPA — Fri, 28 Jul 2023 09:47:00 GMT

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
------------------------------

RE: Pivot table creation

Athiban_Mahamathi — Fri, 28 Jul 2023 10:21:00 GMT

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
------------------------------

RE: Pivot table creation

Sudha_RPA — Fri, 28 Jul 2023 11:23:00 GMT

Hi Athiban,

I have changed the workbook name but im getting new error

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

RE: Pivot table creation

harish.mogulluri — Fri, 28 Jul 2023 13:40:00 GMT

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
------------------------------