I have an excel spreadsheet that has hyperlinks to files on a network drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this (internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried opening
read only and with the write password. No difference.

Any help would be great.

Dan

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



DG wrote:

I have an excel spreadsheet that has hyperlinks to files on a network drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this (internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried opening
read only and with the write password. No difference.

Any help would be great.

Dan

--

Dave Peterson

Thanks I'll try tomorrow.


"Dave Peterson" wrote in message
...
A few people have said that this has stopped a similar problem from
occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



DG wrote:

I have an excel spreadsheet that has hyperlinks to files on a network
drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this
(internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried
opening
read only and with the write password. No difference.

Any help would be great.

Dan

--

Dave Peterson

Please post back with your results--good or bad.

Thanks.

DG wrote:

Thanks I'll try tomorrow.

"Dave Peterson" wrote in message
...
A few people have said that this has stopped a similar problem from
occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



DG wrote:

I have an excel spreadsheet that has hyperlinks to files on a network
drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this
(internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried
opening
read only and with the write password. No difference.

Any help would be great.

Dan

--

Dave Peterson

--

Dave Peterson

Dave,

It did not work. Now the path says C:\data_entry\Pending.xls.

I even saved it out of my email to my desktop and received the same result.

Any other ideas?

Dan


"Dave Peterson" wrote in message
...
Please post back with your results--good or bad.

Thanks.

DG wrote:

Thanks I'll try tomorrow.

"Dave Peterson" wrote in message
...
A few people have said that this has stopped a similar problem from
occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



DG wrote:

I have an excel spreadsheet that has hyperlinks to files on a network
drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this
(internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried
opening
read only and with the write password. No difference.

Any help would be great.

Dan

--

Dave Peterson

--

Dave Peterson

You did fix the hyperlinks to point back at the UNC path before you tested,
right?

If you didn't, try testing that first.

Another way is drop the Insert|hyperlink version and replace them with the
=hyperlink() worksheet function.

=hyperlink("file:///\\ktcserver\data_entry\Pending.xls","Click Me")

If you don't like that, you could actually fix the hyperlinks each time excel
opens the workbook.

You could use the code from David McRitchie's site to get started:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

DG wrote:

Dave,

It did not work. Now the path says C:\data_entry\Pending.xls.

I even saved it out of my email to my desktop and received the same result.

Any other ideas?

Dan

"Dave Peterson" wrote in message
...
Please post back with your results--good or bad.

Thanks.

DG wrote:

Thanks I'll try tomorrow.

"Dave Peterson" wrote in message
...
A few people have said that this has stopped a similar problem from
occurring.
Maybe it'll help you--but you'll have to test it to make sure.

In xl2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



DG wrote:

I have an excel spreadsheet that has hyperlinks to files on a network
drive
file:///\\ktcserver\data_entry\Pending.xls. When I email this
(internally)
as an attachement in Outlook, the receivers can't follow the link. It
points to the Temporary Internet Files\OLKC\....

What do I have set wrong? It worked last week.

FYI the file is password protected. I sent it to myself and tried
opening
read only and with the write password. No difference.

Any help would be great.

Dan

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson