Links in Excel - How do I exclude path?

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Hi,

I am doing some work in Excel that will eventually be
saved to disk and used on an entirely different pc.
There are several spreadsheets with various links. What
I've noticed is that the link contains the full path to
the link, e.g
C:\documents&settings\me\mydocuments\excel\..." etc.
etc. Now I presume that when these files are copied to
disk, it's not going to magically change the links to
read correctly. I've tried manually editing the link and
removing all but the file name that it links to, but it
automatically reverts to the full path. Would appreciate
help on this!

Also, a less worrying problem - one spreadsheet contains
rates, which the other spreadsheets (timesheeets) use as
a look up table. Then finally there's a summary sheet,
which contains totals from all the timesheets. Now, if I
change the rates, is there any way I can get the summary
sheet to update without openign and updating all the
individual timesheets?

(I believe this whole exercise would be more suited to
Access, but has to be done in Excel. I'm more used to
Access, so be patient with me!)

Thanks a lot.
 
When files have been moved and links are no longer valid you should use
Edit, Links, Change Source to correct each broken file link.

There is no way for an unopened file to be updated for changes made in a
file it is linked to. So, you'd have to open each timesheet file and update
links/calc it. You might consider another design where just the hours come
forward from the timesheets and the multiplying by rates takes place at a
higher level.
 
Back
Top