Create Pivot Table: The parameter is incorrect. (0x80070057 (E_INVALIDARG))

[Vishal_Kumar4 (Vishal Kumar)]

Hi, I am creating a Pivot table. When the sheet name contains ’ then i get this error. However if i remove ’ from sheet name it works fine!

SheetName: DBX Q4’24: Gives Error.
SheetName : DBX Q424: Work perfectly.

[mkankatala (Mahesh Kankatala)]

Hi @Vishal_Kumar4

Original sheet name doesn’t have single quote i guess. So when bot trying to search for that sheet it could not find, when you remove single quote it was working.

We have to provide the original name of the sheets then only bot can find.

Hope it helps!!

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Vishal_Kumar4,

Does your sheet name actually contains this ’ single quote ?

If not, why are you trying to use it?

And as you already said, without the ', it works fine. So, why not use it without ’ ?

Regards
Sonali

[Darshan_Sable]

Hello @Vishal_Kumar4,

It works for me. Can you verify if excel contains same sheet name at the time of execution?

Thanks!

[Vishal_Kumar4 (Vishal Kumar)]

Sheet name does have ’

[Vishal_Kumar4 (Vishal Kumar)]

This is the sheet and error message that i have.

In case i give wrong sheet name then error message is different. It says following columns doesn’t exists.

[Darshan_Sable]

@Vishal_Kumar4

check input arguments for Pivot Field, If those are present in excel or not ?

looks like one of the parameter is wrong.

[Vishal_Kumar4 (Vishal Kumar)]

As i mentioned earlier if i remove ’ from sheet name and also from workflow. Pivot works fine. The parameters are fine otherwiese it will give error message that following column doesn’t exists.

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @Vishal_Kumar4,

Have you tried by escaping the single quote in the sheet name?

Try escaping it by providing extra single quote and see what happens?
For e.g DBX Q4’’24

Regards
Sonali