Can excel2003 use relative links instead of absolute links?
Posted on 2009-05-09
Users have creates excel spreadsheets that use links to other excel spreadsheets. The links are absolute ( they have the full path i.e. c:\documents and settings\username\documents). If I move these excel files to another user or to the server share storage area, then the links do not work as the path has now changed. With Win2008 domain, you can easily move the users My Documents to be stored in a file server rather than the PC. But the links will not work as the path will change. Is it possible to change the excel links from absolute to relative (i.e. from c:\documents and settings\documents\folder1\excelfile1 into .\excelfile1 or c:\documents and settings\documents\folder2\excelfile2 into ..\folder2\excelfile2 assuming that the original excel file is in another directory-folder1.)