I would be grateful for any halp with this.

I am trying to reference a cell in a different workbook using the INDIRECT
function but I am returning #REF. This is the formula I am using :

='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010
version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66

Can anyone please help?

Many thanks,

Andrew

The function you'd want to use is =indirect().

But =indirect() won't work if the sending file is closed.

Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

That includes =indirect.ext() that may help you.

===
If you have trouble getting to the site, then search google for indirect.ext.

I found this alternative site:
http://download.cnet.com/Morefunc/30...-10423159.html

I didn't look to see if it was the most current version.

I'd check the original site every so often to see if it's working.

Andrew Mackenzie wrote:

I would be grateful for any halp with this.

I am trying to reference a cell in a different workbook using the INDIRECT
function but I am returning #REF. This is the formula I am using :

='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010
version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66

Can anyone please help?

Many thanks,

Andrew

--

Dave Peterson

The format would be

=INDIRECT("'S:\Regular Procedural Reports - Test Folder AM\Credit Database
2010 version\["&M16&").xls]rPortfolioAnalysis'!$S$66"

but you cannot use INDIRECT on a closed workbook


--

HTH

Bob

"Andrew Mackenzie" wrote in message
...
I would be grateful for any halp with this.

I am trying to reference a cell in a different workbook using the INDIRECT
function but I am returning #REF. This is the formula I am using :

='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010
version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66

Can anyone please help?

Many thanks,

Andrew

Try:

=INDIRECT("'S:\Regular Procedural Reports - Test Folder AM\Credit Database
2010 version\[(+M16).xls]rPortfolioAnalysis'!$S$66")

Regards,

Tom


"Andrew Mackenzie" wrote:

I would be grateful for any halp with this.

I am trying to reference a cell in a different workbook using the INDIRECT
function but I am returning #REF. This is the formula I am using :

='S:\Regular Procedural Reports - Test Folder AM\Credit Database 2010
version\[indirect(+M16).xls]rPortfolioAnalysis'!$S$66

Can anyone please help?

Many thanks,

Andrew


.

i think, the source workbook which you are using in indirect funtion is closed. please verify it and make sure that it is opened.

indirect wont work on closed workbooks.

all the best