#Fix broken links in excel how to
#Fix broken links in excel code

Now, over many years of this abuse, the slot in the screw has become distorted and it has become more difficult to tighten the screw even using a proper screw driver. But, guess what: althought it 'works' to some extent, a pen knife is not the right tool. I've done it, for instance, by using my pen knife to tighten a screw on my spectacles. You might, in a pinch, use a knife to turn a screw.

#Fix broken links in excel how to

RE: Excel Crash Leading To Broken Links SkipVought (Programmer) 6 Jun 13 14:25ДЄnyone with ideas on how to prevent this1) Use each tool within the parameters of its design.Дў) Use a proper tool for an appropriate task.ДЈ) Do not try to use a tool for a purpose for which it is not intended. I've suggested moving this (among multiple other instances of this same potential problem) into a database system, but I wear a lot of hats here, and programming time is basically only granted when absolutely necessary. That just seems really silly and pointless though, because as soon as it crashes again, we'll have to do it again. I appreciate the input! It's looking like the only option we may have is to reconstruct all the links manually. I'd initially assumed that someone had changed our directory structure around in some fundamental way, but I have since verified that that is not the case. The part I find most confusing is why it is happening with backup copies that were saved out before it crashed this morning. So now, instead of these links pointing where they're supposed to, they all point to the local drive of whoever first opened the sheet after it crashed. Sometimes they're excel docs, but most of the time, they're scanned in. The links aren't query references or cell references, but literal hyperlinks to other files.

I alone am our 'database development group', but this spreadsheet was created entirely without my input and has been in use for years. RE: Excel Crash Leading To Broken Links SkipVought (Programmer) 6 Jun 13 11:20 I'm at a loss here! Thanks in advance for any help! We aren't having any connectivity issues, and our folder structure on the server hasn't changed.Дoes anyone have any idea what is going on? Any suggestions on how to restore those links without having to remake them all? Any way to prevent this from happening again? If he opens it on his computer, it breaks the links and they refer to his C: drive, but if I open them, they refer to mine. The file was there, but when we opened it, the links there were all broken as well. So my next thought was to just pull it from last nights backup.

#Fix broken links in excel code

Something like this happened once before, and I was able to use some VBA code to loop through the links and fix them, because they all had the same starting path, but that isn't the case in this spreadsheet. It crashed during loading this morning, and it broke all of the links. We maintain a massive spreadsheet that has hundreds, if not thousands, of links to files all around our server document tree.