Excel Linking Workbooks with Hyperlink Formula!

Hi Dee

Thank you for your post.

Try the following:

1. To create a link between the Location and Payable sheets for the hyperlink, select the cell in the Payable sheet where you want the hyperlink to appear.
2. Type in = then go to the Location sheet and select the cell containing the file path then press Enter.

The file path will not display as a hyperlink at this stage.

To do this:
1. Click on the cell in the Payable sheet where you have just created the link.
2. Edit the formula in this cell as follows:
=hyperlink(cell reference from Location sheet,"friendly name")

where friendly name displays the text you want to appear in the cell. The text must be surrounded by double quotation marks.

This will simply create a link to Workbook 1. If you wish to create a hyperlink to a specific cell or named range in that workbook this will be more complicated because you have created a link between the Payable and Location sheets to display the link to Workbook 1 rather than entering the hyperlink directly into the cell on the Payable sheet.

All I can suggest is playing around with the file path that you have entered into the Location sheet to see if you can get it to reference a particular cell in Workbook 1.

If you look up the hyperlink function in Excel this may shed some light on this.

I hope this helps.
Amanda