I have pivot tables in a workbook that are set up to pull data from another workbook. Both workbooks are located on the same network drive (just in different folders). When I close and reopen the workbook containing the pivot tables I keep loosing the network drive and Excel shuts down and reopens with a repaired version missing the network drive in the pivot. Can someone tell me what I am doing wrong that I keep losing my network drive in the pivots? I am using Excel 2003.