Im creating a link from one cell in a spread sheet from another cell located
on a differnet server - is there a way to write the universal drive letter
code so if the spreadsheet gets moved to a different forlder or server drive
that all the links will stay in tack?

In my example below, the information is coming from a file on our server in
the "LOOKUPS" folder on the "V:" drive of the server.

=SUM('V:\LOOKUPS\[dy36S15.csv]dy36S15'!$D$9)&" X
"&('V:\LOOKUPS\[dy36S15.csv]dy36S15'!$D$11)

Try and use the universal naming convention (UNC path) of the server location
instead of the mapped drive

If this post helps click Yes
---------------
Jacob Skaria


"Rspiva" wrote:

Im creating a link from one cell in a spread sheet from another cell located
on a differnet server - is there a way to write the universal drive letter
code so if the spreadsheet gets moved to a different forlder or server drive
that all the links will stay in tack?

In my example below, the information is coming from a file on our server in
the "LOOKUPS" folder on the "V:" drive of the server.

=SUM('V:\LOOKUPS\[dy36S15.csv]dy36S15'!$D$9)&" X
"&('V:\LOOKUPS\[dy36S15.csv]dy36S15'!$D$11)