Excel Relative Path Links

html is in a subdirectory named folder2. pdf using a relative path. In such cases, updating the paths would require writing parsing code to write the new path to every record. 1 on XP, I'm using LinkTool to add links from one doent to another. I guess this problem is caused by a wrong path, but I don't know how to fix it. One of these is the way the locations of files are described, generally referred to as file paths (i. I have a spreadsheet with a long list of Hyperlinks to different files. a target document or web-page. Learn to use the best new features in Microsoft Excel for Office 365 in Windows. If you restore your toolbars file from a backup do it with Excel down and restore it to the same place. The term you need is relative, not dynamic. How to create Absolute and Relative Links in Word 2007/2003 documents September 17, 2015 By Jeeves MS Word automatically creates a hyperlink when you type the address of an Web page into a document. Relative links, and their paths, can be tricky. html is in the root directory (or main folder) and page2. DXE (data extraction) file so it is a "relative path" instead of a full path. I'm having issues with a workbook that has links to external displays. I'm sharing this because it's a common problem: the client asks me to build something, which happens on my computer, but then I need to send it to them. In general, it is not possible to move CMake generated makefiles to a different location regardless of the value of this variable. Mac OS X is a descendant of both unix and previous Mac OS traditions, and has inherited different - and sometimes conflicting - ways of looking at things from both sides. Can it be modified to replace each file link's path with the same path?. If you restore your toolbars file from a backup do it with Excel down and restore it to the same place. Relative linking. ="Link to this path:->" & xPath. Home Power BI / Power Query Absolute and Relative References in Power Query: R1C1 Excel-style approach. In this blog post, we'll talk about how to create a relative file path. To change it you'll have to modify it using Data Link Manager (Tools --> Data Links --> Data Link Manager). I have a column of cells with hyperlinks to different files. /'s with just the /. While this is easier to use and understand, it's not good practice on your own Web site. I set up a CF for B14 that looks at B2, but I can’t make B2 relative. Based on everything I have read, I need to create a Relative Link, as opposed to an Absolute Link, so that when the flash drive gets plugged into another computer, the hyperlinks will still. The term you need is relative, not dynamic. Pick the Link entire sheet radio button to link a sheet selected from the Select Excel sheet to link to drop-down list. Now that you know how to create, change and remove hyperlinks in Excel, you may want to learn a couple of useful tips to work with links most efficiently. We don't wan't to hard-code our domain, but we also don't want to use the '. An intro to Excel relative references, structured references. This will allow tableau server to locate the excel file when it tries to refresh the extract for excel. It comes, though, with one common problem that I've yet to come across a good solution for: relative paths. For some reason this is replacing both links with the same file. I made all my image hyperlinks as absolute links [ex: =HYPERLINK("S:\Main\Business Card registry\Scanned Cards\"&B2&" "&D2&". Are there any quick ways for you to convert the file paths to hyperlinks so that you can click to open the addresses?. DXE (data extraction) file so it is a "relative path" instead of a full path. This happens when I open an XLSX that contains a link with Calc, make a change such as editing some cell, and then save it. Excel connection string - relative path. Sometimes they'll work in a relative fashion if you omit the path, but that approach is not reliable. So I figure we need all the hyperlink paths to be relative, that is, the address field for each link should be in the form \path\stuff. Take a look at my primitive example: Here is all you need to know about relative file paths: Starting with "/" returns to the root directory and starts there. Re: link cad tables to excel I am assuming that the XL files are very updates to a newer revision. SubAddress Optional Variant The subaddress of the hyperlink. Windows shortcut. In the illustration below, we have selected Excel as the Service, Sheet 1 of Book 1. I would like to have a clickable link to download those files. If I use an absolute path both find it fine but this not what I want. Either type the link statement in the Edit box, or use the Service, Topics, and Items frames to build your link statement. The value it has is a mini syntax all to itself. In certain circumstances, external links created in Excel will use relative paths rather than absolute paths. The absolute path is a known value, but anyway, the file is not opened. That said, it would be great to have something (e. Jekyll is a great static site tool. You are currently viewing LQ as a guest. If you have data in one workbook that you want to use in another, you can set up a link between them. To do that, make sure ASP is added as a Feature of IIS. ' ' a little powerpoint VB macro for turning the absolute paths used in image links ' into relative paths. Step 1 Use the file name of an object, when creating a relative link to an object within the same site. It is best practice to use relative file paths (if possible). Windows shortcut. But not in the Web UI or on a mobile device without the files being downloaded in advance. Adding hyperlinks to features. This is not the case. A relative path is a path relative to the current document's directory. Specifying the Data to Link The Link options area of the New Excel Data Link: dialog box allows you to specify how much of the selected fi le to link to AutoCAD to form the table. Program key functions: search for documents with the broken links, fixing broken links, work with files stored on web-sites and SharePoint servers. txt indicates that ArcMap should look up one level in the file system for a folder named folder and find the file named file. A single dot represents the current directory itself. html, and the specified sections of the page. Here are 24 numbers over two years. It is a mystery to me why Microsoft feels the need to change your file by default when you close it. By default, if no server name or path is specified in html, the file reference is to the default current directory, which in the case of the User Web Server is any file within your www directory. Then, click that hyperlink to go to the specificed location. This article describes how to create absolute hyperlinks and relative hyperlinks in Microsoft Office Word 2010, in Microsoft Office Word 2007, and in Microsoft Office Word 2003. In the Hyperlink base box, type the address or path that you want to use. Relative links can be quite useful since they let PowerPoint find linked files. In TimeLiner – Links, where you are supposed to add an external link to link the model to an external schedule from Microsoft Project or Primavera etc. you sometimes need reference the source file in the same folder as the output file. If I insert a file in the database, its link is something like c:/direc. While hyperlinks use file names to create links to other Excel files, bookmarks use cell references and worksheet names to create links. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Followers 1. ScreenTip Optional Variant The screen tip to be displayed when the mouse pointer is paused over the hyperlink. The address of the destination file is also known as the hyperlink base. Absolute Path Vs Relative Path In Linux: Absolute Path: An absolute path is defined as specifying the location of a file or directory from the root directory(/). GitHub Gist: instantly share code, notes, and snippets. Live on my hosts server simply begining the url with "/" works perfect (eg /img/test. Assume that you have a file path such as. Re: Hyperlink with Relative Referencing In your hyperlink function you specify the path "c:\cars\specifications\" what you need to do is use the "CELLS" function to get the current path of the file. So when your website is example. The following sections contain information on these differences for each of the major operating systems as well as how to link. There are three path options: full path, relative path, and no path. This will allow tableau server to locate the excel file when it tries to refresh the extract for excel. Hyperlinks between documents can be set as relative or absolute, using the Save URLs relative to option in Tools > Options > Load/Save > General. To create a link to a web page, type the Text to display, the Address, and click OK. To stop Excel from changing absolute hyperlinks to relative hyperlinks, in Excel click: File, Options, Advanced. How to change/convert absolute reference to relative reference in Excel? Normally there are several types of cell references you can use in a formula, and each type of cell references can help you achieve different purposes in the formula. Working with Links in Formulas. Choose Tools - Options - Load/Save - General and specify in the Save URLs relative to field if LibreOffice creates relative or absolute hyperlinks. How to use relative paths for linked excel objects in powerpoint I have a powerpoint presentation that is updated daily. Re: Relative Path with different directories - Especially Up One Level Hi Alec, Great to hear it was what you were after The VBA left command is very similar to the left function in excel =Left(text, numberofcharacters). The Searchline Excel is the World’s best selling infrared open path gas detector with over 6,000 units installed in challenging applications throughout industry. Here are the steps: Create a new shortcut using Create Shortcut Wizard (right-click > Shortcut). Determines the path that will be used to find the file specified above. Excel Hyperlinks are an excellent way of organising your data. dtsConfig files are all inside one directory; Execute Package tasks refer to the package to execute using a File connection manager, and that connection manager refers to the. Join Dennis Taylor for an in-depth discussion in this video Understanding when to use absolute or relative references, part of Excel 2013: Macros Lynda. Symbolic links can point to any file or folder either on the local computer or using a SMB path to point at targets over a network (the target machine on the remote end needs to run Windows Vista or later). Relative pathnames work best when you're delivering documents and data to another user. Join Dennis Taylor for an in-depth discussion in this video Understanding when to use absolute or relative references, part of Excel 2013: Macros Lynda. js" In javascript, people sometimes wonder how to do this. Workarounds: since a hyperlink can also open a macro, you could program a macro (or search for it) whitch uses multiple hyperlinks. xlsx has a reference to two. Relative links, and their paths, can be more complex than simply referencing the file's name to the web page. 12 C:\\Users\\geotso\\Desktop\\Book1. When you move the files, the relative hyperlink will continue working as long as the relative path to the target workbook remains unchanged. Either type the link statement in the Edit box, or use the Service, Topics, and Items frames to build your link statement. 'GoogleGuy' actually said "absolute links have less potential for getting messed up [when Google indexes your page]. Then, use the following steps to record a relative reference macro: On the […]. Welcome to LinuxQuestions. Mac OS X is a descendant of both unix and previous Mac OS traditions, and has inherited different - and sometimes conflicting - ways of looking at things from both sides. Using relative references in Excel can be extremely beneficial because they reduce the amount of labor and adjustments the user has to make in order to get the results needed. How to write HTML link code. In the Hyperlink base box, type the address or path that you want to use. This is an easy way to quickly insert an absolute reference. Relative linking. So I figure we need all the hyperlink paths to be relative, that is, the address field for each link should be in the form \path\stuff. To change it you'll have to modify it using Data Link Manager (Tools --> Data Links --> Data Link Manager). Relative URLs can take a number of different forms. >> Understanding Absolute, Relative, and Mixed Cell References in Excel A worksheet in Excel is made up of cells. I am trying to create hyperlinks to documents/XLS files on a our network, and want to use absolute paths. They differ from the relative hyperlinks in that the address is prefixed by a forward slash (for example, /default. the resulting path is. The Hospitality Design Show 2019 Hotel360 Sibos 2019 Create Your Future 2019 HETT 2019 ExCeL London wins bid to host flagship robotics and AI conference Data driven insights for better exhibitor and visitor satisfaction The AEV Conference: a delegate’s perspective London: Where tech thrives London to host hundreds of events for city’s first. If you click the Edit Links button, you will view the Edit Links dialog box as figure 2 shows. A relative hyperlink is a hyperlink that contains an address that is relative to the address of the destination file. But seriously, don't skip this article. Click it and select the ‘Paste Link’ option under the ‘Other Paste Options’ section. Relative links, and their paths, can be tricky. The following sections contain information on these differences for each of the major operating systems as well as how to link. 'GoogleGuy' actually said "absolute links have less potential for getting messed up [when Google indexes your page]. In the Hyperlink base box, type the address or path that you want to use. a target document or web-page. Scenario: PDF1. Excel Hyperlinks -- Relative vs. Relative linking. They differ from the relative hyperlinks in that the address is prefixed by a forward slash (for example, /default. In the example relative path above, the directions are 'go up a level, then go into the. DXE file is liked to the same folder that contains the current drawing, not linked to my C:/AutoCad drawings/Job Name/folder2. For example, when a hyperlink is configured to open another PDF, Revu needs to know where that PDF resides. I hope this all makes sense BH. Therefore, for your internal links, use relative paths instead. Move the file to another folder and you'll see that the link path changes with it. It has to be absolute. So a link that used to be; H:filename. Keep a central reference to the source file's path, so you can edit a single cell to adjust a link's path. Refer to Creating Relative Hyperlinks and Using Relative Hyperlinks as well as Sharing TaskMaps. pathMappings option. 'GoogleGuy' actually said "absolute links have less potential for getting messed up [when Google indexes your page]. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a variety of other topics as well. jpg", FoxFire finds the picture but IE doesn't. it supports paths relative to the user folder (starts with ~) it supports items exclusions via the path-autocomplete. Finishing Up! You can quickly add links in Excel to offsite web pages, internally to sheets in your workbook, or to documents or resources elsewhere. Toggle absolute and relative references. Document-Relative Links. Here are two formulas, one to return the active worksheet’s name, and the other to return the active workbook’s full path and name. To find all links faster, you must use a trick. Ø This program fetches the data from a table and places it in an excel file. This will return the full path to the current file and worksheet. I need help in excel, regarding to Hyperlinks. For example, Figure 3. Excel deliberately stores both the relative and the absolute path of linked items in order to try and find the linked items when the file is opened. Excel inserts hyperlink in a relative mode by default. Path classes are divided between pure paths, which provide purely computational operations without I/O, and concrete paths, which inherit from pure paths but also provide I/O operations. In that case, a link from page1. There is another way to reference files. Identify which cells you want to link. NET Programming with Visual Studio. Re: Hyperlink with Relative Referencing In your hyperlink function you specify the path "c:\cars\specifications\" what you need to do is use the "CELLS" function to get the current path of the file. Return a file with the given filename creating the necessary directories if not present. One thing I don't seem to find is to have relative link paths. Now that you know how to create, change and remove hyperlinks in Excel, you may want to learn a couple of useful tips to work with links most efficiently. When the other data changes, Excel automatically updates the link. I am trying to create hyperlinks to documents/XLS files on a our network, and want to use absolute paths. html would be coded:. Search & Replace to change OLE link paths Problem. Hi All, I am making an analysis tool that uses two Excel file sources via Power Query. 1 for AMP-based sites, see Menu -> Sites -> Site Settings. Before creating a link, make sure you understand how absolute, document-relative, and site root–relative paths work. Excel deliberately stores both the relative and the absolute path of linked items in order to try and find the linked items when the file is opened. As an added bonus, they force you to keep your site structure neat and organized, which is always a good idea. Relative Paths. It can draw anything! I've heard that under the hood all the other drawing elements ultimately use path anyway. There are three ways to do this - the method you use will depend on the location of the source and destination pages in relation to each other. When I say “relative paths in SSIS” I mean the following:. If this succeeds, Excel will update the relative. Hi, GeneralKB is really a great piece of software. Relative R1C1 Reference. I have a colleague at work that has an Excel 2007 spreadsheet (on Windows 7) with multiple hyperlinks to a network drive/folder where the data files are stored. Please be aware that all relative paths are relative from the configuration file that defines the path to the other configuration file - not relative to your webroot or the root of your application. This is an easy way to quickly insert an absolute reference. Hyperlink to a named range. Click any result link to open the full page in a browser. =cell("filename") This function returns the full path and file name of the active sheet. org, a friendly and active Linux Community. From the Arctic Circle to Middle Eastern Deserts, customers have repeatedly selected the Searchline Excel as their preferred choice. I would like to have a clickable link to download those files. PowerQuery is a great instrument that can do much more than just take data from source and pull it in a table or Power Pivot. Its complete location is based on its relation to the directory to which it is linking. This articcle describes the relative (or, ehm, pseudorelative) referencing in Power Query (Get and Transform). Windows shortcut. pathMappings option. html is in a subdirectory named folder2. When you open a file, Excel will first try the relative path to find the file. As formulas become increasingly complex in your Excel spreadsheet you will find all the more use for effectively employing relative reference formulas, as well as. A bookmark in Excel is similar to a hyperlink except that it is used to create a link to a specific area on the current worksheet or to a different worksheet within the same Excel file. The Link Location can refer to a place in a document - such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document. Relative R1C1 Reference. Join Dennis Taylor for an in-depth discussion in this video Understanding when to use absolute or relative references, part of Excel 2013: Macros Lynda. xls; This is an absolute path, but I would like to use a relative path (i. Excel Data Links not working with relative paths I'm using several data links in a drawing, and I have no problem inserting them and updating them using full paths. If you actually need to work with the data rather than to follow links, you can turns this function off or use an alternative clicking/selection method for cells that contain hyperlinks. First, open Sample File. Windows FileDialog to Select File or Folder Path in VBA Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through windows file explorer window. Please be aware that all relative paths are relative from the configuration file that defines the path to the other configuration file - not relative to your webroot or the root of your application. In simpler terms, it is a more advanced type of shortcut. What about you? How do you write relative references in tables? Please share your stories & struggles in the comments section. Relative paths for dynamic hyperlinks are only supported for map layers and not. However, when you create links from within m-files, there are a variety of absolute paths provided:. PDF" to "C:\Users\EXAMPLE USER1\AppData\Roaming\Microsoft\Excel\EXAMPLE1. I made all my image hyperlinks as absolute links [ex: =HYPERLINK("S:\Main\Business Card registry\Scanned Cards\"&B2&" "&D2&". The following sections contain information on these differences for each of the major operating systems as well as how to link. html to page2. For what I'm trying to do, this is a really ugly solution. What is a relative path?. I want an icon in all the 2015 cells that shows how it compares to the prior year. Support relative path to excel/csv sources Currently, when excel file is loaded to Power BI, the absolute filepath is captured in the M query. Excel keeps changing Links - Man about to hurl himself out the window in frustration was located in the path to the external source document that it could just convert my links to relative. xls without the preceding path) instead. Most people are already used to Full Paths: this saves the full folder path to the file. The data source of the Chart Web Part is the Excel file (using Excel Services). The link updates dynamically as long as there is a viable path between the two files. Specializing in Power Query Formula Language (M). The installation path of the database & images is not known at design-time. I would like to have a clickable link to download those files. Das heißt, dass sich Excel nicht den genauen Standort der verlinkten Datei merkt. The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not. It would be nice if relative filepath was supported. html to page2. This article describes how to create absolute hyperlinks and relative hyperlinks in Microsoft Office Word 2010, in Microsoft Office Word 2007, and in Microsoft Office Word 2003. xlb in the user's Application Data area. A relative path is a path relative to the current document's directory. How can I establish a relative path, so that the Access file and the Excel source data sheets are portable to others computers (e. Excel displays the Replace tab of the Find and Replace dialog box. Relative paths change depending upon the page the links are on - they are relative to the page that they are one (hence the name). So, what you do is get the current path by using Applicaiton. Relative linking. A bookmark in Excel is similar to a hyperlink except that it is used to create a link to a specific area on the current worksheet or to a different worksheet within the same Excel file. It would be nice if relative filepath was supported. Two Types of Paths. You can also select the Data Link option from the Tools menu. If you can navigate your drive from absolute paths, then use that as a wayfinder. Open trackers. If you click the Edit Links button, you will view the Edit Links dialog box as figure 2 shows. dtsx files and. There’s no point in saving a few bytes when using relative links…except if each page of your website contains thousands of links. I have an Access DB File which is several linked excel sheets as data sources. The path includes directory and file information. anonymous said Kseda, your one liner does NOT convert absolute paths to relative ones. How to make it RELATIVE?. However, they keep breaking depending on whether the workbook is checked out of Sharepoint or not - because if the document IS checked out, then its file path is to my local folder, but if its NOT checked out, the file path is the website. It would be great if you could set all links, or individual links, within a document to be either absolute or relative. Relative links make it easy to do things like change your domain name without having to go through all your HTML pages, hunting down links and changing the names. In an Excel worksheet, you can create a hyperlink in any cell. Excel Data Links not working with relative paths I'm using several data links in a drawing, and I have no problem inserting them and updating them using full paths. NET Programming with Visual Studio. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink. Step 1 Use the file name of an object, when creating a relative link to an object within the same site. I am having issues with getting the files to save in the correct directories and keeping the same name. In that case, a link from page1. In this blog post, we'll talk about how to create a relative file path. given a relative path, how do i convert it into a full one. On the other hand, relative links connecting pages within your own website should always load in the same browser page. html is in the root directory (or main folder) and page2. Finishing Up! You can quickly add links in Excel to offsite web pages, internally to sheets in your workbook, or to documents or resources elsewhere. How to change/convert absolute reference to relative reference in Excel? Normally there are several types of cell references you can use in a formula, and each type of cell references can help you achieve different purposes in the formula. Introduction. js: using relative paths One of the issues I had with Angular. It looks great on the homepage, but when I for example visit a node, the image isn't found anymore. Google doesn't clearly restricts to use the relative path in canonical AMP tag, as well the "link" tag itself:. Microsoft Access / VBA Forums on Bytes. dtsx file with a relative path (i. Double dots are used for moving up in the hierarchy. Then extract the drive ID and replace the "C". To create a link to an existing file or web page, execute the following steps. Relative R1C1 Reference. com, you could be linking to your contact page from your homepage like this:. I wanna connect to Access 2007 database from Excel 2007. How do I retrieve that path, combine it with the file name "\dashboard\fc. Just as you can save the map with relative pathnames to the data, you can also specify hyperlinks that refer to a location relative to the map. Hi Experts, How can I change the all of the hyperlinks in a Word 2010 document so that the document and a folder containing a group of target documents can be copied while keeping all links intact Make Word Hyperlinks Portable when Copied to Another Computer. The tool work well, but as soon as the file and source files are moved to another location it stops working as the Queries sources from aboslute paths. How can I establish a relative path, so that the Access file and the Excel source data sheets are portable to others computers (e. When the other data changes, Excel automatically updates the link. Changing absolute hyperlinks to relative This is a follow-up to this discussion. In the Hyperlink base box, type the address or path that you want to use. it supports paths relative to the user folder (starts with ~) it supports items exclusions via the path-autocomplete. Relative paths are always with respect to the location of the file containing the file hyperlink. If you link to a file on a local area network, make sure to use a by "relative. If you sync these files down using Desktop Sync, use WebDAV or Egnyte Drive, or cache the files locally on a mobile device, then these links between files will work. Currently the paths to these external linked data sources is absolute. Under the "General" section, click on Web Options. in file A, it will update automatically in file B when you launch it. What is a relative path?. The absolute path for AMP canonical tag is added in v4. Zero or more of the following:. Benefits of choosing a relative path over a full path include better portability and structure overview. \CallTest" (without quotes) and all reusable action will be displayed in drop down list. For more information, please see Absolute and relative hyperlinks in Excel. The fields affected by this include Word's INCLUDEPICTURE, INCLUDETEXT, LINK, RD and HYPERLINK fields. Every time I change a drive letter or folder name where a linked file is stored, I have to re-link it within InDesign. So if the spreadsheet resides in \\File-Server\NewShare\Reports\Databases\LG. Choosing a Link Type; What are Relative Hyperlinks? What is the Hyperlink Base? You can create a relative link to any file (the target of the hyperlink) that is on the same disk drive as your TaskMap (the source of the hyperlink). Ø This program fetches the data from a table and places it in an excel file. Typically, there is a group of cross-linked documents that needs to be burned on CD/DVD or published on a website. com courses again, please join LinkedIn Learning. A server path is the path through the server's directory structure between two files. A hyperlink can be inserted in a cell or a shape in Excel. The basic version of the CELL formula ( = CELL ( "filename" , A1 ) ) returns the full path, file name and sheet name. To create a link to an existing Excel file, select a file (use the Look in drop-down list, if necessary). Click on Files tab. Double dots are used for moving up in the hierarchy. ) and a double-dot (. /' notation, as our files could move around later. If the hyperlinks point to G:, and the reviewer's computer assigns the flashdrive as the E: drive, the path won't work and the documents won't come up. Need to have relative, not absolute, links between PDF files - Adobe Acrobat Windows. Starting today, GitHub supports relative links in markup files. iptv links free & kodi & WORDPRESS THEMES & PLUGINS & SCRIPTS & APPS MOBILE & Games LEARNING PATH: C# 7 and. RSI oscillates between zero and 100. But seriously, don't skip this article. If you sync these files down using Desktop Sync, use WebDAV or Egnyte Drive, or cache the files locally on a mobile device, then these links between files will work. In certain circumstances, external links created in Excel will use relative paths rather than absolute paths. Summary: The ability to link a. So a link that used to be; H:filename. xls) then simply archive the previous. There are three ways to do this - the method you use will depend on the location of the source and destination pages in relation to each other. You want examples of link definitions and how they work? Here’s some Markdown for you. You will first need both your files open. When referring to a file that occurs in the same directory as the referring page, a URL can be as simple as the name of the file. I have an issue with hyperlinks in Excel 2000. When Excel opens a file that contains links (linked workbook), it combines the portions of the links stored in the file with the necessary portions of the current path of the linked workbook. The syntax of the function is: HYPERLINK( link_location, [friendly_name] ) where the arguments are as follows: An optional argument that provides the text to display in the Excel cell. If you have a large Microsoft Office Excel 2010 sheet, or multiple sheets in a workbook, finding links manually is difficult and time-consuming. So I figure we need all the hyperlink paths to be relative, that is, the address field for each link should be in the form \path\stuff. Currently the only method I'm aware of to accomplish relative linking (to make that true backup) is as follows: Open file A & B in the vCurrent folder (causing the links to lose the file path while Excel is open) Do a File-->SaveAs on File B to folder v2011-05-31; Close File B causing the full path to now show in links in File A. Link Location: This is the path and file name to the document to be opened. js" In javascript, people sometimes wonder how to do this. The scraping thing is a non-issue. There are many valid reasons to use absolute paths, not the least of which is their clarity. However, one should not be tempted at any time to copy a symbolic link anywhere, or move the symbolic link across a partition.