Solved

Excel updated links automatically - help

Posted on 2011-09-19
5
194 Views
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:

\\FSVR1\DataStore\Folder1\apples.xls

however it now reads:

\\FSVR1\DataStore\datastore\Folder1\apples.xls

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.

   
0
Comment
Question by:GlenmoranUK
  • 4
5 Comments
 
LVL 8

Expert Comment

by:ragnarok89
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.
0
 
LVL 1

Author Comment

by:GlenmoranUK
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...
0
 
LVL 1

Author Comment

by:GlenmoranUK
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?  
0
 
LVL 1

Accepted Solution

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

kb2553073
http://support.microsoft.com/kb/2553073

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

Author Closing Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now