Hi guys, i have a workbook that has many different data connections and pivot tables from these connections which i want to be updating every hour because the workbook would be opened 247 and data will added to the tables used as connections to this work. so i want it to work such that when new data is added, all the pivot tables update automatically within the workbook....

the workbook exceeds the recommended size so i could not attach but please help!!