can you save an entrire workbook with links
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: can you save an entrire workbook with links

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a main workbook that I update I want I have another 10 workbooks which need to be exactually the same.

    Im on a network so what I was wondering was can you somehow link the whole workbook including code , so that when anything changes on the main book the rest automatically update when opened??

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    brett...what exactly are you trying to do, is this maybe for sharing it with other users? if so, have you looked at the "share workbook" option?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no I was just wondering if you could make other books to link to the main book just for updates changes etc like when you paste a link of data to another workbook and when you open the other workbook it updates the data.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you mean just links? If you want another, or 10 other workbooks A1 value to be the same as your main one, you would put, in each of your 10 other workbooks, the formula :

    =[book1.xls]sheet1!$A$1

    then when you open those copies, it will ask you if you want to update the links.

    is that what you mean?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    kind of it was mainly just the whole book because I also wanted to macro code to update as well like the data example

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hmm...i guess you could have the orignal sheet save itself as 10 different names using the before_close method?, unless you want these updates to go both ways, from original to others, and other changes to the original, in that case, you have me stumped

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Doesn't matter its know big deal thought there might have been an option to link a whole book thanks anyway.

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