Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default creating hyperlinks in excel that won't lose integrity when file m

Okay. I am creating hyperlinks to photographs in an excel spreadsheet. What
I need to know is this: How can I make it so that the integrity of the links
hold up even when the file is taken from my computer and used on a different
machine (ie: handheld). I'm assuming that when I move the file, I also need
to move the folder with the pictures over as well. However, I'm concerned
the files will be too large or that this won't work.

There has got to be an easier way to do this! Anyone?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 221
Default creating hyperlinks in excel that won't lose integrity when file m

I'm sorry. Your question doesn't make sense to me. If you're concerned about
file size, how can you expect to "maintain links" on a handheld if you don't
port the pictures to the handheld? I'm not a handheld user, but it's like
asking if you can email me a spreadsheet with links to pictures on YOUR
computer, and expecting me to be able to see them? What am I missing? I
don't mean to sound obtuse. :)

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Allison" wrote in message
...
Okay. I am creating hyperlinks to photographs in an excel spreadsheet.
What
I need to know is this: How can I make it so that the integrity of the
links
hold up even when the file is taken from my computer and used on a
different
machine (ie: handheld). I'm assuming that when I move the file, I also
need
to move the folder with the pictures over as well. However, I'm concerned
the files will be too large or that this won't work.

There has got to be an easier way to do this! Anyone?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default creating hyperlinks in excel that won't lose integrity when fi

You basically just repeated everything I said. I was just wondering if there
was any other way of doing it. My boss seems to think there is and I am
reaching as far out as I can just to make sure there isn't before I explain
to him that my approach is the best. My intention is to port the pictures to
the handheld but he thinks that is not efficient enough. And its not like I
can put them on a server, as we are using the handhelds out in the middle of
nowhere to collect data.

Thanks for you reply. The affirmation is good enough for me.

"Anne Troy" wrote:

I'm sorry. Your question doesn't make sense to me. If you're concerned about
file size, how can you expect to "maintain links" on a handheld if you don't
port the pictures to the handheld? I'm not a handheld user, but it's like
asking if you can email me a spreadsheet with links to pictures on YOUR
computer, and expecting me to be able to see them? What am I missing? I
don't mean to sound obtuse. :)

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Allison" wrote in message
...
Okay. I am creating hyperlinks to photographs in an excel spreadsheet.
What
I need to know is this: How can I make it so that the integrity of the
links
hold up even when the file is taken from my computer and used on a
different
machine (ie: handheld). I'm assuming that when I move the file, I also
need
to move the folder with the pictures over as well. However, I'm concerned
the files will be too large or that this won't work.

There has got to be an easier way to do this! Anyone?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default creating hyperlinks in excel that won't lose integrity when fi

Are the photos already in an Excel spreadsheet? If so, why not add
another sheet in there with hyperlinks to the photos? You can use the
=HYPERLINK function and include the filename, so that as long as you
save it with the same name it should work on both. Then you only have
one file to deal with.

Hope this helps.

Pete

On Mar 20, 2:38 pm, Allison wrote:
You basically just repeated everything I said. I was just wondering if there
was any other way of doing it. My boss seems to think there is and I am
reaching as far out as I can just to make sure there isn't before I explain
to him that my approach is the best. My intention is to port the pictures to
the handheld but he thinks that is not efficient enough. And its not like I
can put them on a server, as we are using the handhelds out in the middle of
nowhere to collect data.

Thanks for you reply. The affirmation is good enough for me.



"Anne Troy" wrote:
I'm sorry. Your question doesn't make sense to me. If you're concerned about
file size, how can you expect to "maintain links" on a handheld if you don't
port the pictures to the handheld? I'm not a handheld user, but it's like
asking if you can email me a spreadsheet with links to pictures on YOUR
computer, and expecting me to be able to see them? What am I missing? I
don't mean to sound obtuse. :)


****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Allison" wrote in message
...
Okay. I am creating hyperlinks to photographs in an excel spreadsheet.
What
I need to know is this: How can I make it so that the integrity of the
links
hold up even when the file is taken from my computer and used on a
different
machine (ie: handheld). I'm assuming that when I move the file, I also
need
to move the folder with the pictures over as well. However, I'm concerned
the files will be too large or that this won't work.


There has got to be an easier way to do this! Anyone?- Hide quoted text -


- Show quoted text -



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Self creating Hyperlinks HELP PLS Paul Excel Discussion (Misc queries) 3 February 6th 07 10:33 AM
I lose cell comments in Excel when moving a file via a USb drive Marvyn Excel Discussion (Misc queries) 0 January 19th 06 05:02 PM
Excel-update spreadsheet, keeping integrity KP Excel Discussion (Misc queries) 1 November 18th 05 12:46 AM
Creating hyperlinks in Excel HTML converted page. [email protected] Setting up and Configuration of Excel 1 August 11th 05 02:12 AM
Formula Integrity Not Preserved During Sort in Excel 2000 Kevin Excel Discussion (Misc queries) 1 April 15th 05 10:26 PM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"