+ Reply to Thread
Results 1 to 2 of 2

Accessing data in an external link when you dont have the source file

  1. #1
    Registered User
    Join Date
    Herndon, VA
    MS-Off Ver
    Office 2016

    Accessing data in an external link when you dont have the source file

    I have an excel workbook (Call it File A) that contains data from another workbook (File B). File A has a VLOOKUP Formula that uses a named range (LCCODE) where that data exists in File B. The data in named range LCCODE needs to be refreshed yet the person who sent me File B is no longer with the company and cant be reached, no backup or prior version of File B can be found. My question is" can I access the data in the named range LCCODE whose source is File B somewhere in File A? It seems like a temporary version is kept somewhere in File A. I just cant find it. Hopefully this isnt too confusing and there is an answer. Any help is appreciated.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    Any Country
    MS-Off Ver

    Re: Accessing data in an external link when you dont have the source file

    Not in File A but somewhere in temporary folder (you have two). But this is idea only.
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ 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. Chart dont update when source data changes
    By Masun in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2015, 12:34 PM
  2. Replies: 1
    Last Post: 05-15-2015, 04:31 PM
  3. cell of thepivot table that use external file as data source
    By mrkhchan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2014, 11:17 PM
  4. Replies: 5
    Last Post: 03-26-2014, 08:30 AM
  5. Replies: 0
    Last Post: 08-02-2012, 01:33 PM
  6. Replies: 0
    Last Post: 03-07-2012, 06:53 AM
  7. [SOLVED] Import External Data Source File Location Changed
    By Louise in forum Excel General
    Replies: 3
    Last Post: 01-04-2006, 10:50 AM


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