how to know when all workbook pivottable refresh are done +vba code example Example: excel vba Refreshing all pivot tables in workbook ThisWorkbook.RefreshAll