Excel Link to another Excel file and formulas

  • Thread starter Thread starter RICK
  • Start date Start date
R

RICK

I have a formula that I want to "fill" down through my spreadsheet

='I:\filepath\[filename.xls]worksheet!$B$5

When I fill the formula down it does not change the reference.

e.g. ='I:\filepath\[filename.xls]worksheet!$B$6
='I:\filepath\[filename.xls]worksheet!$B$7
='I:\filepath\[filename.xls]worksheet!$B$8

Everything remains as referencing $B$5

How can I get around this issue?

Thanks,

RICK
 
The problem is that your use of an absolute reference is holding the cell
reference constant. Try changing the $B$5 to:

$B5 if you want to keep the column set as B as you drag the formula down or:
B$5 if you want to keep the row set to 5 as you drag the formula or:
B5 if you want both column and row to index as ypou drag/fill the formula.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top