S
Saar Ben-Attar
I created an excel file which extracts information from several workbooks.
In one column, the addressing is relative (i.e.:
='[file_name1.xls]Spreadsheet_name'!$B$25), while in other columns the
address is absolute (i.e.: ='C:\Documents and Settings\SaarB\My
Documents\[file_name1.xls]Spreadsheet_name'!$B$25).
How can I turn all addresses to relative format? This is essential so that
when copying the files to another computer, the file identifies all other
excel files which it is linked to.
Any help would be most appreciated.
Saar
In one column, the addressing is relative (i.e.:
='[file_name1.xls]Spreadsheet_name'!$B$25), while in other columns the
address is absolute (i.e.: ='C:\Documents and Settings\SaarB\My
Documents\[file_name1.xls]Spreadsheet_name'!$B$25).
How can I turn all addresses to relative format? This is essential so that
when copying the files to another computer, the file identifies all other
excel files which it is linked to.
Any help would be most appreciated.
Saar