Linking pictures to spreadsheet

[philcud]

Good morning,

i have a spreadsheet with links to many thousands of photos. i want to
burn this spreadsheet and photos to disc. how can i ensure that when i
open this spreadsheet from the dvd that all links will be working
correctly?

i will be opening this spreadsheet up on various computers

cheers

 

[philcud]

Good morning,

i have a spreadsheet with links to many thousands of photos. i want to
burn this spreadsheet and photos to disc. how can i ensure that when i
open this spreadsheet from the dvd that all links will be working
correctly?

i will be opening this spreadsheet up on various computers

cheers

found the answer more quickly than i expected. i need a relative
hyperlink. eg "Pictures\IMG_3152.JPG" will always open the folder
pictures that is in the same folder as the spreadsheet, so they can
all be moved, burned to disk, moved to usb and they will always
work....