Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am currently working on a spreadsheet where I am referencing drawings throughout the document. I have the drawings saved in the same folder as the spreadsheet.

When sending the document externally is there any way that I can keep the same hyperlinks that I have used? Currently it's reading through my C: drive or /desktop file path which the recipients can't find.

share|improve this question

If it where me I would include them all in a .zip or .rar file and just leave the links with no UNC path, giving instructions in the E-mail to extract the files to a folder before opening the Excel document.

share|improve this answer

When creating the hyperlink just make sure the address specified does not include a path. When following a hyperlink without a full path, the actual path is relative to the excel file folder. You could include a relative path is required.

Examples

Path = DrawingFile.dwg              looks in same folder as excel file for DrawingFile.dwg
Path = .\DrawingFile.dwg            looks in same folder as excel file for DrawingFile.dwg
Path = ..\DrawingFile.dwg           looks in parent folder of excel file for DrawingFile.dwg
Path = Drawings\DrawingFile.dwg     looks in Drawings folder in as excel file folder for DrawingFile.dwg
Path = C:\Drawings\DrawingFile.dwg  looks in folder C:\Drawings\ for DrawingFile.dwg
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .