Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks don't work when emailing attachment
Actually I checked it but it didn't need changing. The original is on the
same network path that the hyperlinks point to. I did a test. Created a new spreadsheet called hyperlink test.xls which resides on the network drive. In cell A1 I typed "hello" and inserted a hyperlink to a word document on the network drive. Saved and closed the file. Opened up the file. Hovered over the link and it was correctly pointing to the network drive and document. I clicked it and the word document opened. I closed the document. Then I did as you suggested and went to File -- Properties -- Summary Tab and entered C:\ in the Hyperlink base field. Clicked OK. Hovered over the hyperlink now and it shows File:///C:\phonelist.doc. So it changes it imediatly. I know macros and understand the =hyperlink() function. The problem is, I'm not the one linking. Her is how I resolved the problem. Email the user and advised that if the file/spreadsheet is out on the network there is no need to send the spreadsheet in an email. email a link to the spreadsheet. That will ensure that her people are seeing the correct file and it saves space in my exchange server. Thanks for your help. Dan "Dave Peterson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emailing an Excel document with hyperlinks | Excel Discussion (Misc queries) | |||
emailing excel worksheet from excel program d/n work? how to fix? | Excel Worksheet Functions | |||
Problems emailing attachment from Excel | Excel Discussion (Misc queries) | |||
Hypoerlink to a Local file and emailing the file as an attachment | Excel Discussion (Misc queries) | |||
why does a workwook increase in size when emailing as attachment | Excel Discussion (Misc queries) |