I have a workbook with numerous worksheets with data from these feeding 5 pivot tables on 4 of these sheets.
I am trying to produce some vba which will update the pivot tables when there is a worksheet change.
Is it possible to do this at workbook level, defining the sheets to be refreshed when a change occurs. Also there is a power query in the workbook that I don’t want to update.
Hope someone can help!