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
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
Last edited by tek9step; 12-11-2009 at 07:10 AM.
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
Yes there are sumifs in the formulas which dont display on closed files.![]()
Please Login or Register to view this content.
Is there any other source of info that i can refer to for this.
tek9step
Last edited by tek9step; 12-11-2009 at 07:50 AM.
Thank Teylyn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks