Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Linked Microsoft Word & Exce documents looking to old server

Posted on 2012-04-11
5
Medium Priority
?
391 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

715 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