Retrieve formula linked to closed xls file

Hello

Can anyone enlighten me as to how can i retreive formula result in sheet A linked to data in sheet B if sheet B is closed.. just as a simple example as on the live file the formulas are linked to several sheets.


Thanks

tek9step

Tek9step,

that depends on the formula. Some, like VLOOKUP work fine on closed workbooks, others, like SUMIF don't, but the morefunc.xll add-in has a few additional formulas that do work on closed books.

Download here: http://xcell05.free.fr/morefunc/english/index.htm

Thank Teylyn I have tried to access the file http://xcell05.free.fr/fclicksql/fclick.php?2 but unfortunatley it dont let me shows me an error upon download

Please Login or Register  to view this content.

Yes there are sumifs in the formulas which dont display on closed files.

Is there any other source of info that i can refer to for this.

tek9step

see here
http://www.excelforum.com/excel-work...ll-5-05-a.html