Creating a link to an excel file on a shared folder

[baggarwal]

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.

 

[SydneyGeek]

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]

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]

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]

No option for hyperlink. Do I have to change my editor to rich text or html?

 

[SydneyGeek]

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:

<file://C:\My Documents\MyFile.xls>

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

Denis