Is there a simple way of updating pivot with VBA?

Lets simplify my question by saying that I have a workbook "Calculate", and two others called "2018" and "2019".

In Calculate I have a pivot-table "Pivot1" which has data from workbook 2018, sheet1 A:C.

Is there an easy way of updating Pivot1 so it changes source from workbook 2018 to 2019 but still fetches from A:C?

Thanks for all help!

Hey again!

I used record macro with the change datasource function and got this neat code:

Please Login or Register  to view this content.

It works great!