i want to hyperlink pictures in a spread sheet so that i can send to a
client, but in doing so hyperlinking a pic works fine on my pc, but once i
send the workbook the client can not veiw the pictures as the hyper link
looks for the file path that it was oringinaly create,

how do i hyperlink these pictures so that can be relvant to the workbook?

Try this:

File|Properties|Summary tab
Hyperlink base: (fill in the appropriate base location)

For more information, search Excel Help for: hyperlink base address

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"L.Birch" wrote:

i want to hyperlink pictures in a spread sheet so that i can send to a
client, but in doing so hyperlinking a pic works fine on my pc, but once i
send the workbook the client can not veiw the pictures as the hyper link
looks for the file path that it was oringinaly create,

how do i hyperlink these pictures so that can be relvant to the workbook?

thanks Ron, but a message about hyperlinks can be bad or something, is that
normal?

"Ron Coderre" wrote:

Try this:

File|Properties|Summary tab
Hyperlink base: (fill in the appropriate base location)

For more information, search Excel Help for: hyperlink base address

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"L.Birch" wrote:

i want to hyperlink pictures in a spread sheet so that i can send to a
client, but in doing so hyperlinking a pic works fine on my pc, but once i
send the workbook the client can not veiw the pictures as the hyper link
looks for the file path that it was oringinaly create,

how do i hyperlink these pictures so that can be relvant to the workbook?

I don't recall seeing a warning about hyperlinks. Links: yes, hyperlinks: no.
What message are you getting?

Alternatively, you might be able to use the HYPERLINK function. In that,
you explicitly enter the path. Check Excel Help for more information.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"L.Birch" wrote:

thanks Ron, but a message about hyperlinks can be bad or something, is that
normal?

"Ron Coderre" wrote:

Try this:

File|Properties|Summary tab
Hyperlink base: (fill in the appropriate base location)

For more information, search Excel Help for: hyperlink base address

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"L.Birch" wrote:

i want to hyperlink pictures in a spread sheet so that i can send to a
client, but in doing so hyperlinking a pic works fine on my pc, but once i
send the workbook the client can not veiw the pictures as the hyper link
looks for the file path that it was oringinaly create,

how do i hyperlink these pictures so that can be relvant to the workbook?

A Very simple fix for you would be aquire some webhosting for your pictures
something similar to a photobucket account. Use this for storing your non
secure pictures (not that I don't trust the file storage places but just to
be on the safe side). Then hyperlink to the web addy. Crude, yes, but it
works and is user friendly.

"L.Birch" wrote:

i want to hyperlink pictures in a spread sheet so that i can send to a
client, but in doing so hyperlinking a pic works fine on my pc, but once i
send the workbook the client can not veiw the pictures as the hyper link
looks for the file path that it was oringinaly create,

how do i hyperlink these pictures so that can be relvant to the workbook?