Linking Files

[John Muscatiello]

I have an estimating spreadsheet with links to all my vendors pricing
spreadsheets. I work on a network and a sample path is:
='J:\Depts\Estimating\_Price Schedules\[Sea Group
12.05.07.xls]Agreement'!$F$77

The problem I am having is if a copy all my data to a zip drive to work on
at home I loose all my links because it can no longer find the files. I keep
all my files including on the zip drive in the "Estimating" folder.

Is there any way to change the path name to the common folder "Estimating"
regardless of the drive? Something that might look like this below.

='...\Estimating\_Price Schedules\[Sea Group 12.05.07.xls]Agreement'!$F$77

I also use AutoCad and it has this feature in it.

 

[Dave Peterson]

How about just opening the file and changing the links?

Edit|Links|Change source
(in xl2003)

I have an estimating spreadsheet with links to all my vendors pricing
spreadsheets. I work on a network and a sample path is:
='J:\Depts\Estimating\_Price Schedules\[Sea Group
12.05.07.xls]Agreement'!$F$77

The problem I am having is if a copy all my data to a zip drive to work on
at home I loose all my links because it can no longer find the files. I keep
all my files including on the zip drive in the "Estimating" folder.

Is there any way to change the path name to the common folder "Estimating"
regardless of the drive? Something that might look like this below.

='...\Estimating\_Price Schedules\[Sea Group 12.05.07.xls]Agreement'!$F$77

I also use AutoCad and it has this feature in it.

 

[John Muscatiello]

I have some 50 or so links to this spreadsheet, so it becomes a tedius task
to do each time.

How about just opening the file and changing the links?

Edit|Links|Change source
(in xl2003)

I have an estimating spreadsheet with links to all my vendors pricing
spreadsheets. I work on a network and a sample path is:
='J:\Depts\Estimating\_Price Schedules\[Sea Group
12.05.07.xls]Agreement'!$F$77

The problem I am having is if a copy all my data to a zip drive to work on
at home I loose all my links because it can no longer find the files. I keep
all my files including on the zip drive in the "Estimating" folder.

Is there any way to change the path name to the common folder "Estimating"
regardless of the drive? Something that might look like this below.

='...\Estimating\_Price Schedules\[Sea Group 12.05.07.xls]Agreement'!$F$77

I also use AutoCad and it has this feature in it.

 

[Dave Peterson]

If the only thing that changes is the drive letter, could use do an edit|replace
J: with x:?

Or specify enough info to make the info unique:

edit|replace
what: J:\depts\
with: x:\mydept\
replace all

I have some 50 or so links to this spreadsheet, so it becomes a tedius task
to do each time.

How about just opening the file and changing the links?

Edit|Links|Change source
(in xl2003)

I have an estimating spreadsheet with links to all my vendors pricing
spreadsheets. I work on a network and a sample path is:
='J:\Depts\Estimating\_Price Schedules\[Sea Group
12.05.07.xls]Agreement'!$F$77

The problem I am having is if a copy all my data to a zip drive to work on
at home I loose all my links because it can no longer find the files. I keep
all my files including on the zip drive in the "Estimating" folder.

Is there any way to change the path name to the common folder "Estimating"
regardless of the drive? Something that might look like this below.

='...\Estimating\_Price Schedules\[Sea Group 12.05.07.xls]Agreement'!$F$77

I also use AutoCad and it has this feature in it.