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.