Hyperlink in Excel 2007: Mac

[kapil.tanwani]

The issue I have is with Excel 2007 for Mac:

I have a spreadsheet with the Column A including particular names. I
also have a folder of JPG images which have images starting with the
EXACT same letter-casing and identical names to those in Column A of
my spreadsheet.

I wish to link all of Column A's particular names with the appropriate
matching images stored in the folder I mentioned.

I have tried the following method:
=HYPERLINK("file://ServerName/Users/myUserName/Desktop/Folder/
subFolder/subSubFolder/subSubSubFolder/" &A1&".jpg", "Click here")

Assuming subSubSubFolder has the JPG images I mentioned earlier, I
wish to establish a link between Column A in my spreadsheet and the
JPG images stored in my subSubSubFolder. I however get an error
message saying that I've created a 'Circular Reference', which is not
what I wanted to do at all.

Furthermore, the cell A1 doesn't even say "Click here" as I want it
to, It just shows the number 0 and it is also clickable. This means
that a link is created but when I hover the mouse-over to see what the
path is then the final outcome is the following:

file://ServerName/Users/myUserName/Desktop/Folder/subFolder/subSubFolder/subSubSubFolder/0.jpg

and there is no file by the name of 0.jpg.

Please help. It would be much appreciated. Keep in mind this is on a
Mac. Maybe on a PC, the above method may have worked. Kindly help me.

Thanks!

 

[John McGhie]

You need to ensure that A1 actually contains text.

This works: =HYPERLINK(D13&E13&".jpg","Click Here")

Cheers

The issue I have is with Excel 2007 for Mac:

I have a spreadsheet with the Column A including particular names. I
also have a folder of JPG images which have images starting with the
EXACT same letter-casing and identical names to those in Column A of
my spreadsheet.

I wish to link all of Column A's particular names with the appropriate
matching images stored in the folder I mentioned.

I have tried the following method:
=HYPERLINK("file://ServerName/Users/myUserName/Desktop/Folder/
subFolder/subSubFolder/subSubSubFolder/" &A1&".jpg", "Click here")

Assuming subSubSubFolder has the JPG images I mentioned earlier, I
wish to establish a link between Column A in my spreadsheet and the
JPG images stored in my subSubSubFolder. I however get an error
message saying that I've created a 'Circular Reference', which is not
what I wanted to do at all.

Furthermore, the cell A1 doesn't even say "Click here" as I want it
to, It just shows the number 0 and it is also clickable. This means
that a link is created but when I hover the mouse-over to see what the
path is then the final outcome is the following:

file://ServerName/Users/myUserName/Desktop/Folder/subFolder/subSubFolder/subSu
bSubFolder/0.jpg

and there is no file by the name of 0.jpg.

Please help. It would be much appreciated. Keep in mind this is on a
Mac. Maybe on a PC, the above method may have worked. Kindly help me.

Thanks!

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]