+ Reply to Thread
Results 1 to 3 of 3

External workbook - reference with single link?

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Question External workbook - reference with single link?

    Is there a way to specify the filename for an external workbook that can be referenced throughout the spreadsheet? In my case it would be better if I could change the single reference instead of having to change it throughout the entire spreadsheet everytime I needed to use data from a different file.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,697

    Re: External workbook - reference with single link?

    Not sure I understand you problem properly but could you not put external link in say A1 and file name in A2 i.e. A1 value C:\Myfolder\Data\ and A2 value ThisFile.xlsx and use a construction like A1&A2 in your spreadsheet?

    Alf

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: External workbook - reference with single link?

    In another case, if your external reference is going to be used by the formula's of your current workbook then assigning it in a cell will leads you to use INDIRECT function.

    In that case the default worksheet function (i.e. INDIRECT()) will fail when the external workbook is NOT IN OPEN.

    So you need to go for some other approach like INDIRECT.EXT of MoreFunc Addin Or PullData Function which you can get by doing google search.

+ 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