Excel updated links automatically - help

Posted on 2011-09-19
Last Modified: 2012-05-12
Hello experts,

We have a rather complex system that has been created using excel and uses links to other files spread in several directories.

Today we have noticed that all the file locations have been updated meaning the calculation sheets can not be updated.  All the links have been updated in the same way, for example the link should read:


however it now reads:


The share name seems to have been duplicated.  However this has not happened to excel documents that reference an excel document in the same folder.

What I need to understand is why this has happened and any possible resolutions.

Many thanks for taking time to read this.

Question by:GlenmoranUK
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
  • 4

Expert Comment

ID: 36560738
You probably won't find the reason why this happened... In fact, the only reason I could imagine is that someone went in and either updated the formula or accidentally did a find/replace.

I think you're easiest fix is to do a find/replace and correct your formulas. At least you won't have to correct them one at a time.

Author Comment

ID: 36560855
There are hundreds of files and links all over the place..  ;o)

I tried one find/replace and it took over half an hour..  

Thus trying to find out what caused it...

Author Comment

ID: 36561134
It gets even more bizarre..  After doing a restore from backup of several files we see that on one PC the paths are OK and on another PC the paths have the duplication.  Same file, accessed the same way, same Excel version.....

Anyone have CSi's number?  

Accepted Solution

GlenmoranUK earned 0 total points
ID: 36567029
Reasoning found.  Was due to an excel 2007 security update:


Once removed the links were back to normal on the machines that were having the error.

Author Closing Comment

ID: 36594666
After investigation this was found to be the cause of the problem

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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 Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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…

690 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