+ Reply to Thread
Results 1 to 3 of 3

Indirect File links not working when linkfile is closed

  1. #1
    Registered User
    Join Date
    07-19-2006
    Location
    Jamaica
    Posts
    86

    Indirect File links not working when linkfile is closed

    I'm trying to link some different sheets that all are in the same folder, but I want to avoid absolute file references.

    The quotes will always be in the same folder for the same project so the folder structure would e.g. be as be below:

    1.png

    File structure would be similar to below

    2.png

    The summary file will extract data from the quotes and and present them in a a table. I want the summary file to be a template where the only thing a person needs to enter is the filename and the an indirect formula pulls out the data. That is easy enough, but it requires the quotes to be open. If I close the qoutes I get #REF. Open the quote and the value is shown again. How do I avoid that (can't have all the files open all the time)?

    /Møller
    --
    M?ller

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Indirect File links not working when linkfile is closed

    Hi, that is the nature of the INDIRECT function: it works only on opened files

    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Indirect File links not working when linkfile is closed

    Short answer is you can not. there are other approaches, see the link below. But you have not provided much information to give a more specific answer

    https://www.excelforum.com/excel-gen...nal-files.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using INDIRECT to search a closed file
    By zendetta2608 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2015, 07:58 AM
  2. [SOLVED] VLOOKUP from closed file using INDIRECT function
    By Ben in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2006, 08:58 PM
  3. Replies: 4
    Last Post: 05-12-2006, 02:00 PM
  4. Use INDIRECT function to reference a value in closed file
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 12:05 PM
  5. Use INDIRECT function to reference a value in closed file
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04:05 AM
  6. Use INDIRECT function to reference a value in closed file
    By Saravan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Use INDIRECT function to reference a value in closed file
    By Saravan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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