R
rrousseau
I just downloaded this function and am having trouble getting it to
work.
When I enter the reference value in the function formula dialog box,
the reference evaluates correctly to the contents of the cell in the
closed worksheet. Yet when I close the function dialog box, the cell
in my spreadsheet says "#REF". I have tried all combinations of the
remaining parameters, but nothing returns to my spreadsheet excep
"#REF".
This is what I have in the formula:
=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)
work.
When I enter the reference value in the function formula dialog box,
the reference evaluates correctly to the contents of the cell in the
closed worksheet. Yet when I close the function dialog box, the cell
in my spreadsheet says "#REF". I have tried all combinations of the
remaining parameters, but nothing returns to my spreadsheet excep
"#REF".
This is what I have in the formula:
=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)