ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Linking pictures to spreadsheet (https://www.excelbanter.com/links-linking-excel/217270-linking-pictures-spreadsheet.html)

philcud

Linking pictures to spreadsheet
 
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

Linking pictures to spreadsheet
 
On Jan 21, 10:15*am, philcud wrote:
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....


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com