Excel VBO - Refresh All

DarrenAtkins — Tue, 19 Jul 2022 12:39:29 GMT

Hi

I would like to refresh an excel s/sheet using the excel VBO. Does anyone have the VB code they can share with me so I can create my own action please?

Thank you

Re: Excel VBO - Refresh All

ewilson — Tue, 19 Jul 2022 14:39:15 GMT

Hi @DarrenAtkins,

Are you using the latest Excel VBO from the Digital Exchange? If so, there's an action called Autocalculate. You should be able to set that to True (if it's not already) and Excel will automatically perform re-calculations.

Cheers,
Eric

topic Excel VBO - Refresh All in Product Forum

Excel VBO - Refresh All

Re: Excel VBO - Refresh All