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:
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???