I am using Excel 2007. i have a pivot table in one workbook using a data table from another workbook. when i just have the pivot table workbook open and i refresh the pivots i get the reference is not valid error. i can only refresh the pivots if the other workbook is open. how can i correct this. i never had this issue in excel 2003.