+ Reply to Thread
Results 1 to 2 of 2

Please help me understand, how two different excel files with values linked works

  1. #1
    Registered User
    Join Date
    06-13-2022
    Location
    United States
    MS-Off Ver
    2016
    Posts
    36

    Please help me understand, how two different excel files with values linked works

    So I have two excel files, lets call master file and slave file.
    so slave worksheet have some values that's linked to master worksheet, when looking values its path of file location example "D:\Google Drive\Masterfile"
    if I copy paste those two files at different location link does not work, because slave file is looking for values at specific path, what I am trying to do is I need few copies of both slave and master file, slave file I understand but master file, has to be always same name and same location? how can I copy master file so that I can fill different data. thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,945

    Re: Please help me understand, how two different excel files with values linked works

    Open copied slave, then open copied Master.

    If the links dont update to the new location, you may have to do the update manually
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. I don't understand how =MOD(ROW(),2)=0 works
    By jtds in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2019, 12:28 PM
  2. Help to understand how this formula works so I can adjust it?!
    By Treebeardz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-14-2017, 03:43 PM
  3. need help with excel don't understand how your site works
    By mat2017 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-01-2017, 05:33 PM
  4. [SOLVED] Someone please help me understand WHY this WORKS!?!?
    By dml1783 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2016, 10:59 AM
  5. [SOLVED] Get statement - Please help me understand how this works
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-29-2015, 08:31 PM
  6. [SOLVED] I want to understand what is behind A2 cell ? How this works ?
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2014, 01:36 PM
  7. How to save values only from linked Excel files?
    By jmadam39 in forum Excel General
    Replies: 3
    Last Post: 11-30-2005, 01:30 PM

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