Losing links when SAVE workbook

Clr wrote:
Tried this and got exactly this (with the two leading dots)
../Approved Drawings/D28X04302_RevA_2of2.dwg

The .., as you no doubt know means go up a level (from the directory which
contains this application). It indicates that the link is being treated as a
relative link rather than an absolute one.


The only other thing I can figure to do is to work only off my C: drive and
then copy up to the Network.......funny tho, how this all happened "all of a
sudden" after months and months of working ok using Win2k/Excel2k.


From what you said earlier it sounded like the problem was with links created
using Excel 2003. Is that the case?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

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.

Time for me to crash here now..........I got to get an early start tomorrow
boarding up the house.........the big winds are supposed to start tomorrow
afternoon, so hopefully I'll get it all done in time. I won't get back to
work 'till Tuesday, but I'll be fooling around with it some here at home
"between boards" G.............

Thanks again for everything,
Vaya con Dios,
Chuck, CABGx3






"Bill Manville" wrote in message
...
Clr wrote:
Tried this and got exactly this (with the two leading dots)
../Approved Drawings/D28X04302_RevA_2of2.dwg

The .., as you no doubt know means go up a level (from the directory which
contains this application). It indicates that the link is being treated
as a
relative link rather than an absolute one.


The only other thing I can figure to do is to work only off my C: drive
and
then copy up to the Network.......funny tho, how this all happened "all
of a
sudden" after months and months of working ok using Win2k/Excel2k.


From what you said earlier it sounded like the problem was with links
created
using Excel 2003. Is that the case?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

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.

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.

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.

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.