Excel Link to another Excel file and formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RICK - 23 Jan 2008 23:00 GMT

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

Reply to this Message

Sandy Mann - 23 Jan 2008 23:19 GMT

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.

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I have a formula that I want to "fill" down through my spreadsheet
>
[quoted text clipped - 13 lines]
>
> RICK

Reply to this Message

Gord Dibben - 23 Jan 2008 23:20 GMT

Remove the $ signs from $B$6 before dragging.

Gord Dibben MS Excel MVP

>I have a formula that I want to "fill" down through my spreadsheet
>
[quoted text clipped - 13 lines]
>
>RICK

Reply to this Message