how do i edit link source in whole workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with over 900 customers. Each has it's own link which used
to have our server as the source. We had server problems, and somehow now the
links all use the c-drive on my workstation as the source, and cannot be
opened. I have started to go through and edit the links, one by one, but it
is so time consuming. There has got to be a better way. What if I do a "save
as" and save the entire workbook on the server...will that change the link
source? I tried doing the Edit/Link/Source thing, but the "link" option in my
edit drop down menu is faded, not an option I can click on. Help!
 
Is it as simple as replacing the drive letters in the links (so the rest of the
path stays the same)?

If no, is there a pattern to what needs to be fixed?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
break links not working 39
edit link source 1
change links to a different source in the same workbook 2
Workbook Contains Links To Other Data Sources? Where? 2
Update links in multiple workbooks simultaneously 2
Linking workbooks together 1
"Formula too long" when changing linked sources?? 2

Back
Top