How would I connect my source table (one worksheet) in one excel workbook to my pivot tables in another workbook on the same network (they are on different drives on the same network). I do not want to have my flat database in the pivot table workbook i put on the network. And do they have to be in the same format (.xls and .xlsx)? Thanks