Solved

Linked Microsoft Word & Exce documents looking to old server

Posted on 2012-04-11
5
389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

617 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