Excel Hyperlink

C

chuparfaan

Board Regular
Joined
Feb 15, 2009
Messages
59
Dear Experts,

I don't know how relevent this question is to this forum, so if you can point me in another direction i would be grateful.

Anyway here goes, I have an excel spreadsheet which contains general data and in column C i want to insert a hyperlink that will take me to a photo. Now i know i can do this, the thing is i want to send the spreadsheet to a client and for them to click the hyperlink and see the photo. However, the hyperlink i use only links to the folder on my system.

Is there any way of creating a folder that is "Stand alone" i.e. does not link back to my system?
Or
Is the any good way of displaying photos in excel - (i want to minimise the size of the file i send).

If you guys have any ideas i would be very grateful

Many thanks

Chuparfaan
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Hi,

You could create a folder (for example - D:\Photos) which contains all photos you want to send and the Excel workbook. Now you can hyperlink the photos from the folder in the workbook without it being system dependent. You just need to zip/rar the entire folder and send it.

Another option would be to embed the photos in the workbook.

The file size will depend on how many photos you have.

OR, if its possible you can create a shared network drive, save all photos in that and hyperlink the network drive in Excel... But you'll need to consult your sys admins to do this....
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Moving hyperlinked files to a different folder
Replies
2
Views
47
DJKempo
D
P
  • Solved
New Worksheet Hyperlinks
2
Replies
12
Views
340
Peter_SSs
Peter_SSs
A
  • Question Question
Replacing =CELL() Function for use on Excel Web and =HYPERLINK() function
Replies
0
Views
535
ajones
A
J
  • Question Question
Pulling Data From ~300 Individual Sheets Onto a Master Sheet
Replies
1
Views
400
ranman256
ranman256
SaraWitch
  • Solved
Open Word template hyperlink as a new Word document (.docx), not as the original template (.dotx)
Replies
7
Views
521
Misso101
M

Forum statistics

Threads
1,225,482
Messages
6,185,262
Members
453,283
Latest member
Shortm88

Share this page

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
Back
Top