Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
How to use INDIRECT? | Excel Worksheet Functions | |||
How to use INDIRECT? | Excel Discussion (Misc queries) | |||
INDIRECT.EXT | Excel Worksheet Functions |