J johnb Apr 5, 2004 #1 How do you loop all pivottables in a workbook to refresh them when source data in changed? TIA johnb