| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDIRECT.EXT issue
Can anyone tell me what's wrong with this formula? It only works when
the linked sheet is open, just like the INDIRECT formula. The details are fine, as it does work when the referenced sheet is open. But I need it to work when the sheet is closed... =INDIRECT.EXT("'W:\Transportation\Overseas Operatations\FCA\FCA Reports and Updates\FCA In Transit Reports\["&TEXT(B2,"yyyy.mm.dd")&" FCA in transit report SZH.xls]Po List'!$A$3") Thanks much, Jamison |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Can I use INDIRECT.EXT for this? | Excel Worksheet Functions | |||
| sum() using indirect() | Excel Worksheet Functions | |||
| #REF using =INDIRECT... | Excel Worksheet Functions | |||
| indirect | Excel Discussion (Misc queries) | |||
Threaded Mode
