Filter Pivot Table Error

[lq_c (chan lq)]

Hi, I’m unable to use a variable in the configure filter property. I received an error message (0x800A03EC). Is there a way to resolve it and do you have a sample of how the filter pivot table works?

[Gokul001 (Gokul Balaji)]

HI @lq_c

Use Kill Process activity before filtering the Pivot table

Process Name : “EXCEL”

Use Some Delay for 5 sec

Check out the thread

Excel - How to deal with Exception from HRESULT: 0x800A03EC

A few workarounds to the common error code 0x800A03EC. Before you check it out, please make sure you are running the latest available stable Excel package from our Official feed. If you have encountered this error during your Excel processing, please make sure: you can access the file your are working on (in case of shared drives → the file is not open by another user) the file is not open already open in a non-standard editing mode (read-only, password-protected, etc) there is no conflicti…

Excel app. Scope exception: HRESULT 0x800A03EC

Hi Martin, From my knowledge, this error usually occurs when a variable is not declared. Please share the version number of “UiPath.Excel.Activities” package and if possible your workflow. If not, at least specify what are the exact activities you are using in your workflow(screenshots would be helpful too). Related forum post: Also check if the excel file is opened/used somewhere else. Thanks!

[Sudharsan_Ka]

HI @lq_c

Try this alternative

Record a macro to filter the pivot table in excel and copy the macro send here

If you make a dynamic vba code you can use Invoke VBA activity in the process and and pass your dynamic filtring values in the variable

Regards
Sudharsan