|
|
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.
|