Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
i'm trying to take advantage of the indirect.ext function in the morefunc.xla add-in. it's a great tool. my question is this: when the file my function is referencing closes, i only get one good set of numbers. upon a recalculation, all computations return with the #REF! error like the book does not exist. i think my syntax is right. what am i doing wrong?
my formula looks like this (Q5 in example):
=INDIRECT.EXT("[WTR04.xls]"&P5&"!$BN$34")
if i use the full path as suggested by the formula, my formula looks like this (Q4 in the example):
=INDIRECT.EXT("C:\Documents and Settings\All Users\Documents\[WTR04.xls]Mar04!BK35")
the latter equation will always return the #REF! error. i've read mr longre's help files, but can't seem to nail down what i'm doing wrong here. an example looks like this:
as it stands i'm utilizing the first of the two equations and trying not to recalculuate when using this workbook, but that is growing cumbersome as it's evolved to a 'daily-entry' type workbook.
if anyone has any ideas/suggestions, i'd love to hear them. thanks!
my formula looks like this (Q5 in example):
=INDIRECT.EXT("[WTR04.xls]"&P5&"!$BN$34")
if i use the full path as suggested by the formula, my formula looks like this (Q4 in the example):
=INDIRECT.EXT("C:\Documents and Settings\All Users\Documents\[WTR04.xls]Mar04!BK35")
the latter equation will always return the #REF! error. i've read mr longre's help files, but can't seem to nail down what i'm doing wrong here. an example looks like this:
as it stands i'm utilizing the first of the two equations and trying not to recalculuate when using this workbook, but that is growing cumbersome as it's evolved to a 'daily-entry' type workbook.
if anyone has any ideas/suggestions, i'd love to hear them. thanks!