+ Reply to Thread
Results 1 to 4 of 4

Linking tables cells in 2 different workbooks

  1. #1
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    37

    Exclamation Linking tables cells in 2 different workbooks

    Hello,

    I need to link cells from tables in 2 workbooks, so whenever a cell value is updated in the table in workbookA it should update in the table in workBookB and vice versa!

    Well I linked them and they works perfectly in real time as long as they are both open, but when one is closed I have connection and link error!

    I don't know if there is a way to this in different method then linking, maybe a formula maybe a vba it's too hard to figure out!

    I attached the 2 workboooks here, hope someone has an idea

    Thanks in advance forall.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: Linking tables cells in 2 different workbooks

    Hi BassemCH

    In doing some web searching it looks like Excel can read from closed files but can't write to them. I did see a suggestion that Access might be able to write to a closed file that was linked to it using VBA.

    I'd be interested to know if you solve this. I'll keep watching..
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    37

    Re: Linking tables cells in 2 different workbooks

    I'm not actually looking to write in closed workbook, I just want to mirror the cells in both workbooks

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: Linking tables cells in 2 different workbooks

    Hey BassemCH,

    You say "mirror" and I thought you wanted to write to the closed file. Do you only want to read from the closed file? How do you see if it is mirrored in the open file? What does "mirror the cells" mean?

+ 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. Linking workbooks with tables and lists
    By Excelski in forum Excel General
    Replies: 0
    Last Post: 02-26-2019, 10:30 AM
  2. Excel 2007 : linking workbooks and cells
    By Lou54 in forum Excel General
    Replies: 0
    Last Post: 05-30-2012, 02:36 PM
  3. Linking two cells in two workbooks
    By robertgrimsley in forum Excel General
    Replies: 1
    Last Post: 03-28-2009, 03:14 AM
  4. Linking two cells in two workbooks
    By robertgrimsley in forum Excel General
    Replies: 1
    Last Post: 03-27-2009, 02:49 PM
  5. linking tables from 2 workbooks
    By Tal72 in forum Excel General
    Replies: 2
    Last Post: 06-15-2008, 05:37 PM
  6. [SOLVED] for DS et al. : linking workbooks and cells
    By Larry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2006, 01:15 PM
  7. Linking cells from different workbooks
    By tillytee1 in forum Excel General
    Replies: 4
    Last Post: 05-11-2006, 10:39 AM

Tags for this Thread

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