+ Reply to Thread
Results 1 to 5 of 5

Retrieve formula linked to closed xls file

  1. #1
    Valued Forum Contributor tek9step's Avatar
    Join Date
    05-27-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    356

    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
    Last edited by tek9step; 12-11-2009 at 07:10 AM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: Retreive formula linked to closed xls file

    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

  3. #3
    Valued Forum Contributor tek9step's Avatar
    Join Date
    05-27-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    356

    Re: Retreive formula linked to closed xls file

    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
    Last edited by tek9step; 12-11-2009 at 07:50 AM.

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,363

    Re: Retreive formula linked to closed xls file


  5. #5
    Valued Forum Contributor tek9step's Avatar
    Join Date
    05-27-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    356

    Thumbs up Re: Retreive formula linked to closed xls file

    Thank Teylyn

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1