Digital Exchange

 View Only
last person joined: yesterday 

This community is a place to discuss Blue Prism DX assets and development.

Expand all | Collapse all

Excel VBO - Unable to get the PivotTables property of the Worksheet class

  • 1.  Excel VBO - Unable to get the PivotTables property of the Worksheet class

    Posted 07-13-2023 08:49

    Hi, Community

    I'm testing with Pivot functions of Excel VBO, which is simple enough that it 1)creates pivot table, and 2)add rows to the table. However, the following error pops up persistently at the "Add Row to Pivot tables" action, and the same happens to "Add Values to Pivot tables" and "Add Filters to Pivot tables" actions as well. Can anyone explain the meaning of this error and some possible causes? 


    HongJoo Choi

  • 2.  RE: Excel VBO - Unable to get the PivotTables property of the Worksheet class
    Best Answer

    Posted 07-14-2023 05:35

    Hi Hon,

    We receive an error message that says 'unable to get pivotTables property of the worksheet class' when we attempt to perform pivot table actions on a worksheet that doesn't actually have a pivot table. Please make sure you are providing the correct worksheet name as input for the 'Add Row to Pivot Tables' / 'Add Values to Pivot Tables' actions.

    Alternatively, you can create an Excel template file with the desired pivot table. Then, paste the necessary data into the worksheet and create a custom action to refresh the pivot table.

    Athiban Mahamathi -
    Technical Consultant,

Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support


The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.