Creating a link to an excel file on a shared folder

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
Hi All:

I have an excel file on a shared folder in drive J. I want to send the link to the file to someone through e-mail? How do I setup such a link? I use Microsoft Outlook?

Is there anyway that the person who receives the file can open it straight from the J Drive and make changes to it and resave it on there? Or is it going to still open up as a temporary file?

Thanks in advance for your help.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
When you attach a file, you can attach the hyperlink instead. Do this:

1. Click the Attach icon, browse to the file
2. At the bottom right, is the Insert button. It has a drop-down arrow at the extreme right. Click that, select Insert as Hyperlink, and you're done

Denis
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
Hi there

The only options I get from the insert drop down is insert attachment or insert text? Is there something else I have to do enable hyperlinks?
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Strange. I tested it before posting, and that worked for me.
Are you sure there is no hyperlink option? It was below the other two, with a divider line. I tested it in Outlook 2003.

Denis
 

baggarwal

Well-known Member
Joined
Jul 10, 2002
Messages
591
No option for hyperlink. Do I have to change my editor to rich text or html?
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hmmm... tried on Outlook 2002 and the option isn't there. I'm not sure whether it's new to 2003 or not.

However, you can use the following syntax instead:
Code:
<file://C:\My Documents\MyFile.xls>

You need the angle brackets, and the file:// designation. Outlook will turn it into a hyperlink.

Denis
 

Forum statistics

Threads
1,136,305
Messages
5,674,984
Members
419,541
Latest member
freddyboots

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top