networked workbooks
networked workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: networked workbooks

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Singapore
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    There are two workbooks in two networked computers.
    Workbook b.xls contains sheets("b1"), Sheets("b2")
    Workbook c.xls contains sheets("c1"), Sheets("c2")

    In another computer i want to create a new workbook a.xls. In a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").

    b.xls and c.xls updates frequently. How can i create a.xls and make a.xls automatically changes with the changes of b.xls and c.xls.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Create your new workbook ('a'). Copy the data in 'b', plus as many blank rows and columns as you think will be filled up eventually. Then just Paste Special- Paste Links onto the sheet in 'a' where you want the data to appear. Do the same for all the other sheets. You can copy entire sheets in this way, but it usually leads to a very large workbook. Hope that helps.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    Just a point can you not share the book / ss with password access to a token ring on the network

    IE YOUR Shared workbooks network inside main network

    Thus no updating, set show changes at once and every one can update togethen, as set save to autosave every 2 mins,,,,,


    Rdgs
    ==========
    Jack

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com