The pivot tables are part of the same workbook. Question: is there any way to have a magic update button (on the main sheet)that would update all pivot tables in the workbook when user wants. Same as for indvidual pivots (although there only works if you have one of the table’s cell selected)
I don’t want to use auto-update every x minute