Refresh Pivot tables

[RománSánchez_Pé]

Hi Team,

I was wondering if there's any chance of implementing the action "Refresh Pivot Table" in a new release of the DX MS Excel VBO?

Thank you & Kind regards,

-----------------------------

------------------------------
Román Sánchez
RPA Developer
------------------------------

[LeonardoSQueiroz]

Hello,

Which version are you using?

Check this extended version, it has some additional features: https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended

Compliments,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

[Tejaskumar_Darji]

Yes this is a must. Can we please have Refresh Pivot action in native Excel VBO please. @ewilson can you help sir.

Right now this is in extended but we have used native VBO eevrywhere and cant change all actions now to extended.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------

[michaeloneil]

Hi 

I created a couple of actions for this previously if its useful to you. You will need to create a new action Refresh Pivot Tables and add a code stage with the following code:

Dim wb As Object
wb = GetWorkbook(handle,workbookname)

wb.Activate()

wb.RefreshAll

Inputs are handle and workbookname. Alternatively I have one that refreshes a named pivot table do the same thing and create an new action with a code stage using the following code:

Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname)
 
ws.Activate()

ws.PivotTables(Pivot_Name).PivotCache.Refresh

Inputs are handle, workbookname, worksheetname and Pivot Name

Hope this helps.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[Daniel_Sanhueza]

I used the same code as @Michael ONeil on my action "Update Excel" so I can say that works perfectly 🙂 

Regards

------------------------------
Daniel Sanhueza
RPA Professional Developer
Deloitte
America/Santiago
------------------------------

[ewilson]

Hello @Tejaskumar_Darji,

Thanks for the shoutout. I've looked through the Extended VBO on the DX, but there is no Refresh Pivot action. If you have one in yours, it's likely because someone within team added it themselves, or you received that VBO from somewhere other than the DX.

Having said that, we can certainly add an action for this in the core Excel VBO.

I would ask that in the future, any requests for new functionality should be directed to the DX Ideas page. That way we have traceability as those ideas go straight to our backlog.

https://digitalexchange.blueprism.com/site/global/ideas/index.gsp

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[ewilson]

@RománSánchez_Pé,

The Excel VBO, available on the DX as v10.2.0, has been updated to include Refresh All and Refresh Pivot Table actions (thanks for @Michael ONeil for sharing his code).

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[LeonardoSQueiroz]

Thanks Eric! (=

------------------------------
Leonardo Soares
RPA Developer
América/Brazil
------------------------------

[Michael_S]

Wow nice work everyone, and thanks especially @Michael ONeil for sharing the code!

------------------------------
💙 Michael
(I'm part of the SS&C Blue Prism Community Team)
------------------------------

[faheemsd]

Dear @ewilson

Thank you very much for your efforts in integrating the "Refresh Pivot Table" functionality within the Excel VBO.

------------------------------
SYED FAHEEM
RPA Lead
Arab Financial Services
Manama
------------------------------