Hello Experts,

I have a folder containing 33 excel files and all of them are Pivot Tables in one sheet.

All files are linked to One external Data Source in Access which gets updated once a month.
Please advise if all 33 pivot tables in 33 files can be updated (Refreshed) using a macro.

Best Regards/VKS