I have used earlier versions of a basic spreadsheet with earlier versions of Excel (2003, 2007).
Maybe it wouldn't be able to build it relative without then being cofoldered.
I know that isn't a satisfying answer but its a reasonable work around.
I've discovered that when you link to another workbook in Excel, if you close the file and then attempt to move or copy it, the moved/copied workbook will have all of its links broken. However, if I copy Workbook1 and paste it directly onto the desktop and open it, Excel informs me that my link is broken.
To be clear, here is a simple example: There are two workbooks ("Workbook1.xlsx" and "Workbook2.xlsx") in a folder on the Desktop ("C:\Users\Brad\Desktop\Folder1\"). Now, cell A1 shows the formula as "='C:\Users\Brad\Desktop\[Workbook2.xlsx]Sheet1'! Apparently, even though the full path is spelled out in the original Workbook1, Excel is actually storing a relative path to Workbook2.
In Workbook1, Sheet1, cell A1, the formula is "='C:\Users\Brad\Desktop\Folder1\[Workbook2.xlsx]Sheet1'! Is there a way I can change this behavior so that I can move or copy a workbook without ruining the links?
I have a less-than-ideal workaround for some files where I open Workbook1 and use the "Save As" dialogue to save a copy in a new location, which preserves the links. Does it still do it if you link workbooks that are not in the same folder to begin with?
It provides information about discounts, the latest updates of our products and software news from Just take a few seconds to subscribe to our newsletter, and you will stay up to date regarding your software from Extendoffice.
This issue is really frustrating me, and I'm not sure if I'm just googling with the wrong keywords or what.
For example, if the linked file is C:\Mydir\and the source data file is C:\Mydir\Files\Source.xls, you can move the files to the D drive as long as the source file is still located in a subfolder called "files". If the linked file and the source data file are not on the same drive, the drive letter is stored with a path to the file and file name. If the linked file and the source data file are in the same folder, only the file name is stored. If the source data file is located in a folder that is nested in the same root folder as the linked file, a property is stored to indicate the root folder.
All portions of the path that are shared are not stored. If the source data file is one folder down from the linked file, a property is stored to indicate this.
Step 1: Please uninstall previous version of the softawre. Step 2: Please go to download and install the latest version of the software from here.