Relative formatting

  • Thread starter Thread starter Saar Ben-Attar
  • Start date Start date
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
 
External links are always 'absolute'. XL doesn't display the path if the
file is open.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing column reference for number of formulas at once 1
Remove workbook reference but keep worksheet references 2
relative path in OLEDB string 3
MS Access 4
Excel 2007 Saving Cell types in XLS format 1
Scatter plot / Data from matrices? 1
Excel VBA - macro that copies the sheets to another workbook 3
copying a conditional format gives the whole range 3

Back
Top