To link data in one workbook to another workbook, must both reside in the same directory?
A Alan Jul 11, 2006 #1 To link data in one workbook to another workbook, must both reside in the same directory?
C CLR Jul 11, 2006 #2 No, but it's usually more convienient when possible, in case your MIS dept likes to change the names of paths/directories.......... Just call out the entire path in the link........ Like........ ='c:\yourpath\[Stats June.xls]Sheet1'!$A$1 hth Vaya con Dios, Chuck, CABGx3
No, but it's usually more convienient when possible, in case your MIS dept likes to change the names of paths/directories.......... Just call out the entire path in the link........ Like........ ='c:\yourpath\[Stats June.xls]Sheet1'!$A$1 hth Vaya con Dios, Chuck, CABGx3