J
jamison.folland
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
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