Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Links / November 2003

Tip: Looking for answers? Try searching our database.

Changing Links

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Allen - 16 Oct 2003 15:42 GMT
Hi

I have just changed a server which many spreadsheets
linked to for data.  Having named the new server someting
different these spreadsheets can no longer find their
source.

As I have hyndreds of these to change is there a way to
do it quickly or does each one have to be updated
manually?

Thanks
Bill Manville - 17 Oct 2003 04:00 GMT
> As I have hyndreds of these to change is there a way to
> do it quickly or does each one have to be updated
> manually?

I have a link manager utility which could help solve this problem for
you.  If you would like a free copy, please email me at
Bill_Manville @ compuserve.com  
(without the spaces).

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Neil Llewellyn - 19 Nov 2003 10:12 GMT
Hi Bill,

I am going through the same painful process because the
data has been moved to a new server..... the Accounts
department is ready to string me up if I dont find an
easier way to modify the links!

Can you help?

Thanks
Neil

nllewellyn(remove this)@usceurope.com

>-----Original Message-----
>> As I have hyndreds of these to change is there a way to
[quoted text clipped - 11 lines]
>
>.
Bill Manville - 20 Nov 2003 11:34 GMT
> I am going through the same painful process because the
> data has been moved to a new server..... the Accounts
> department is ready to string me up if I dont find an
> easier way to modify the links!
>
> Can you help?

Sure - send me an email requesting Link Manager to
Bill_Manville @ compuserve . com
without the spaces

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Mark - 19 Oct 2003 08:36 GMT
Paul,

Changing lots of links is easy with Navigator Utilities at www.robbo.com.au.
(an Excel add-in)

Just go to the Link Navigator and select Multiple Files.  It's then easy to
change lots of links in a single run.

regards
Mark

> Hi
>
[quoted text clipped - 8 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.