Quote:
Originally Posted by Andrew Mackenzie
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