Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Losing links when SAVE workbook
Dear All, We experienced the same problem and I discovered a solution. Use the FQDN of the server instead of simply using the netbios name. For instance, use "server1.domain.com" instead of simply using "server1". In Chuks example below, try defining the location of the target file for the hyperlink as follows: \\Surfer.domainname.com\Approved Drawings\D28X04302_RevA_2of2.dwg I hope this helps. Thanks. Alvin Mike c wrote: you are r not the only one with this problem. Here is my reply to a similar post on 9/22/04 that Bill also responded to...HELP I am experience the same problem except mine is between excel files. It appears the problem is in the directory structure of our network. If I hyper link to a file in the same or lower (in the tree) directory or even a link in the directory to a sub-directory, they work fine. But if I link to a directory closer to the root it will work fine until the file is calced or saved. In the address the beginning of the address is relaced with".." "CLR" wrote: Hi Dick.......... Thanks very much for taking your time to analyze my problem and offer your assistance. Agreed, this is a puzzler. I've had so much trouble with the "MIS Connection" since I've been here and I feel this one is along the same lines because they are forever changing Servers and software and paths over there. Yes, you have a good grasp of what was happening. Old links that I had hand-typed in and some that I had installed with the Concatenation macro all worked ok, and then all of a sudden in the middle of the day all links added from that point on began to go away, when saving originally, then just on their own after a few minutes.........I could re-create them and all would be fine, but then they would go away again....... and for some reason my paths ALL changed from \\Surfer\Approved Drawings\ to c:\ then it was the end of the day...........The problem did not exist when I would set it up to work on local drives, only to the Network location. It was driving me nuts, and I did have a talk with MIS last Friday, and we were off Monday and Tuesday because of the Hurricane but today I'm back and ran a little Macro that Leo gave me some time back to globally change my 2200 links and re-set them all to \\Surfer\Approved Drawings\ and i'ts like the problem never happened..........all is well now. I do still have the Hyperlink base still set at C: as was suggested as a change from a setting of "nothing"..........but I can SAVE and go right along now and nothing is going away..........so, unless it pops up again, I can't even re-create the problem now. Thanks again, Vaya con Dios, Chuck, CABGx3 "Dick Kusleika" wrote in message ... Chuck This is a real head scratcher. My first inclination was that the network path changed, but that would mean that none of the links to that network location would work, which is not the case. Then I thought that your macro was not concatenating properly, but you say that some of the links created by the macro work and some don't, so that's not likely it. I also thought that you might be screwing something up either with a change to the macro or the way that you were typing in the links, but you say that you can recreate the links and they work fine, but eventually you get the error message - although I'm not clear on when they are breaking. Do I have this right so far? The first thing to try is to set your Hyperlink Base to the network share, i.e. \\Surfer\ Then modify your links so they are absolute hyperlinks. If all your hyperlinks point to the same share and that share is the Hyperlink Base, the absolute-ness of the hyperlinks should hold. If you have a hyperlink like ..\Approved Drawings\Myfile.dwg you need to change it to \\Surfer\Approved Drawings\Myfile.dwg Try this manually on one of the "broken" hyperlinks, save, close and reopen and see if it works. If it does, try it on a couple more of the broken ones and see if they work. If that doesn't work, you should test to see if you have a corrupt workbook. Open a new workbook and copy the columns necessary to create the hyperlink to the new sheet. Don't copy the sheet, just copy and paste special the data. Then create a macro to make a bunch of hyperlinks and see if they work. If they do, I suspect the workbook is corrupt and you would need to start recreating it. If the workbook isn't corrupt, then you may be able to use the FollowHyperlink event to get around whatever the problem is. Let me know and I can help you write a macro for that event. None of the above, to me, is a real solution to the problem (unless it's a corrupt workbook) but hopefully we can find something that works around whatever the real problem is until someone can figure it out. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "CLR" wrote in message ... Hi Bill......... I just don't know..........I thought I was putting in an absolute link each time, the old way when I was hand keying them in, I ALWAYS typed the full path, and then with the macros, I concatenated in the full path again as well, but still I got the ".." in your test. I had a chat with our MIS guy and he always gets kinda sheepish when I start suggesting that possible "monitors" and "chokes" that he might have on my LAN drop might be causing my problems, and he finally admitted today that "we've got connection problems with that server".........I just KNOW in my heart that they've caused the problem with their fritzing around but can't prove it and can't even complain cause I'll be the bad-guy. His switching things around has caused me to lose links in the past. I told him today I was going to switch it all over to my C: drive and he sorta panic'd, saying it HAS to be on the network...........well I blew that off and started anyway but ran into so many "hard coded" problems with my macros and stuff that I backed out. But, if I just cannot solve this thing, that is what I will have to do eventually. The old links that I hand typed mostly in 2000 but some in 2003 seemed to be ok, and even some of the ones that I produced by macro in 2003, but all of a sudden in the middle of the day on 8-31-04 the switchover occured, right between two rows......one was fine, and the next bad, and at this point I was putting them all in with the 2003 macro I posted earlier, but I have no way to go back and check how each one was inserted. And of course when I save off to another location off the network, things seem to work fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
#VALUE ! errorr for links to other workbook | Excel Worksheet Functions | |||
Warning when I try to save an Excel 2003 workbook. | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |