MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking different Workbooks... Can this be done withOUT using drive letters??

Posted by Chris Seabridge on November 20, 2000 1:27 PM


I have to link data from one workbook to another, which is easy. However, Excel keeps putting in the full drive location of the source spreadsheet.. for example:
Cell A1, which is pulling data from another workbook looks like:

='W:\Lotus123 Conversions\[source.xls]Sheet1'!$A$1

is there anyway to reference or link my "Source.xls" worksheet to my other excel file without hardcodeing drive letters??? if he moves this sheet from one drive (w:\) to another (p:\), then none of the links'll work.

can i avoid this using another formula or something???



Posted by John Rigali on November 22, 2000 7:49 AM

I think you're stuck on this one. If the drive letters are assigned to shared network drives or folders, you could substitute the network path, but that just takes you out of the frying pan and into another frying pan. Example:

='\\AnotherComputer\Spreadsheets\Lotus123 Conversions\[source.xls]Sheet1'!$A$1

If source.xls is moved from the Lotus123 Conversions folder (which is what you said might happen), this link won't work anymore.