Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Linked Microsoft Word & Exce documents looking to old server

Posted on 2012-04-11
5
Medium Priority
?
392 Views
Last Modified: 2012-05-26
One of our old file servers died, so we setup a new one and copied all the data to it.  Trouble is when we open some Word documents that have  linkes to Excel (and Vice Versa) files which were on the old file server, the document hangs for a long time whilst it looks for the file on the old, now non existant server.  All the docs are now on the new box, but I just don't wish to wait for minutes whilst the software attempts to contact a long since dead server!

We have a large amount of docs with this issue, is there a way to bulk replace the link to the old server, or can you force the doc to stop looking to the old server (keypress etc.) so it can be re-pathed?

Thanks in advance.
0
Comment
Question by:icuadmin
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37832135
disable update from link while opening document
link.JPG
0
 
LVL 1

Author Comment

by:icuadmin
ID: 37832156
I removed the tick to update automatic links at open on Word, then opened a doc from the server and it still tried to contact the old file server.  Is this the option you meant?
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37832184
0
 
LVL 1

Accepted Solution

by:
icuadmin earned 0 total points
ID: 37836878
I'd love to assign the points for the script, but the guy customised it and can't remeber how exactly.  For now I have placed an entry in the users hosts file which point anything for the old server to the new.
0
 
LVL 1

Author Closing Comment

by:icuadmin
ID: 38014422
Please close and supplied answers were incomplete....
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question