Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alvin
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find links to another workbook Patricia Excel Discussion (Misc queries) 1 January 21st 05 10:33 PM
Links w/in same workbook not working JenR Excel Discussion (Misc queries) 3 January 21st 05 12:54 AM
#VALUE ! errorr for links to other workbook Janez Banez Excel Worksheet Functions 2 January 15th 05 11:58 PM
Warning when I try to save an Excel 2003 workbook. digicast Excel Discussion (Misc queries) 0 January 11th 05 08:55 PM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 10:27 PM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"