+ Reply to Thread
Results 1 to 4 of 4

Linking sheets from different computers

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    UK
    MS-Off Ver
    2013
    Posts
    12

    Linking sheets from different computers

    Hi,

    I didn't know exactly what to name my problem so I apologise if there's already a thread about it.

    I have basic knowledge of Excel but by no means a pro.

    I'm looking to see if it's possible to have a Master sheet on my computer and when I update it another sheet on a different computer will auto update the numbers, even if the file isn't open?

    If it is possible, can you please give me a laymans explanation on how to do it.

    Thanks in advance,
    Dan

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Linking sheets from different computers

    Hi -

    Obviously, the two files must be linked, and you have to have access between one computer and the other. If you change the master file, the change won't occur in the second file until the second file is opened. Then it will be updated. I suppose if you have a function (such as SUMPRODUCT) that can draw information from a closed file, you could run into a problem. For example, you change something in the master file that is referenced in File 2. But you also have File 3 open which has a SUMPRODUCT function that reads from File 2. That probably won't work since File 2 wouldn't be updated.

    There might be a VBA way of briefly opening a file to refresh it and then close it? Or maybe you can directly edit a closed file with VBA. That is out of my expertise.

    Sorry I'm not much help. You may want to rethink how your file system is structured to get rid of this problem.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Registered User
    Join Date
    06-09-2020
    Location
    UK
    MS-Off Ver
    2013
    Posts
    12

    Re: Linking sheets from different computers

    Hi,

    My apologies for taking so long to reply, I didn't even realise I had one until I came back looking on the forum.

    Thanks for your answer.
    I only want it to copy and paste a couple of numbers at most.
    Is it possible that when linking to my Master Sheet that I could reference my IP address and the location of the document eg,

    ='C:\198.196.1.17\Users\Dan\Documents\[MasterSheet.xlsx]Page1'!$E$19

    That is obviously a made up IP address, but would Excel have the capability to extract data this way?
    If not, do you have any suggestions that would give me the same results?

    Again, apologies for the late reply.

    Thanks for your help already.
    Dan

  4. #4
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Linking sheets from different computers

    Hi -

    No need to apologize. I think this is definitely a VBA application. You would need to write (or have someone write for you) a function that will open your files and update them, extract the information you need and then close the files. Again, this is outside my expertise other than I know it's not really possible with the 'out of the box' Excel functions.

+ 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. [SOLVED] Excel Macro Runs on Some Computers, Not All- Stalls for computers where it fails to run
    By jamie.harris in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-25-2018, 04:54 PM
  2. Getting sheets with macros to work on other computers.
    By The Toke Master in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2016, 09:49 PM
  3. Trying to Solve Conditional Formatting Formula Linking 2 sheets linking dates
    By Jetpilot69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2014, 01:57 PM
  4. Linking sheets
    By Balliol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2010, 06:35 AM
  5. Linking Sheets
    By jab123 in forum Excel General
    Replies: 2
    Last Post: 05-06-2010, 10:55 PM
  6. Linking Sheets
    By Nubbers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2007, 05:54 PM
  7. Linking sheets
    By Alex01 in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 06:12 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