I want to use the indirect formula so I can put the directory path in a cell
and link to it.

I want to link to a a spreadsheet located here - S:\Pricing\Performance
Templates\2005 Q3\Performance Templates\

The spreadsheet is called "Partner 1.xls" and the worksheet is called
"Review - Creditor" and I want to look at cell A1.

How would I write this?

Thanks in advance.

It looks at though you want to access a closed workbook, doesn't work with
INDIRECT.

Try Laurent Longre's MOREFUNC utility. It is free, and you can find it at

http://xcell05.free.fr/


--

HTH

RP
(remove nothere from the email address if mailing direct)


"fullers" wrote in message
...
I want to use the indirect formula so I can put the directory path in a
cell
and link to it.

I want to link to a a spreadsheet located here - S:\Pricing\Performance
Templates\2005 Q3\Performance Templates\

The spreadsheet is called "Partner 1.xls" and the worksheet is called
"Review - Creditor" and I want to look at cell A1.

How would I write this?

Thanks in advance.

Thanks for that.

Have just tried using the formula indirect.ext as follows:

=INDIRECT.EXT("'S:\Pricing\Performance Templates\2005 Q3\Performance
Templates\[Partner 1.xls]Review - Creditor'!A1")

unfortunately it doesn't seem to work. Anything obvious you can spot that I
am doing wrong with the formula?

Thanks


"Bob Phillips" wrote:

It looks at though you want to access a closed workbook, doesn't work with
INDIRECT.

Try Laurent Longre's MOREFUNC utility. It is free, and you can find it at

http://xcell05.free.fr/


--

HTH

RP
(remove nothere from the email address if mailing direct)


"fullers" wrote in message
...
I want to use the indirect formula so I can put the directory path in a
cell
and link to it.

I want to link to a a spreadsheet located here - S:\Pricing\Performance
Templates\2005 Q3\Performance Templates\

The spreadsheet is called "Partner 1.xls" and the worksheet is called
"Review - Creditor" and I want to look at cell A1.

How would I write this?

Thanks in advance.

Sorry, I probably can't help as I don't use that utility, I have a custom
utility that I use.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fullers" wrote in message
...
Thanks for that.

Have just tried using the formula indirect.ext as follows:

=INDIRECT.EXT("'S:\Pricing\Performance Templates\2005 Q3\Performance
Templates\[Partner 1.xls]Review - Creditor'!A1")

unfortunately it doesn't seem to work. Anything obvious you can spot that
I
am doing wrong with the formula?

Thanks


"Bob Phillips" wrote:

It looks at though you want to access a closed workbook, doesn't work
with
INDIRECT.

Try Laurent Longre's MOREFUNC utility. It is free, and you can find it
at

http://xcell05.free.fr/


--

HTH

RP
(remove nothere from the email address if mailing direct)


"fullers" wrote in message
...
I want to use the indirect formula so I can put the directory path in
a
cell
and link to it.

I want to link to a a spreadsheet located here -
S:\Pricing\Performance
Templates\2005 Q3\Performance Templates\

The spreadsheet is called "Partner 1.xls" and the worksheet is called
"Review - Creditor" and I want to look at cell A1.

How would I write this?

Thanks in advance.