I have a workbook with a number of pivot tables as well as the source data for each pivot table. Some of the source data sheets needed to be deleted so now if I try to refresh the corresponding pivot table I get "Connot open pivot table source file '[Std Mthly Rpt.xls]Report_2' ". I recreated the source file again and would like to know if I can link the pivot table to this new source file or do I need to create a new pivot table??
Thank you all for your time.