+ Reply to Thread
Results 1 to 7 of 7

links between workbooks

  1. #1
    Forum Contributor
    Join Date
    05-12-2016
    Location
    spanaway
    MS-Off Ver
    2007
    Posts
    112

    links between workbooks

    hi all, I have a question regarding links:
    say I have three workbooks - 1. June Budget, 2. June production and 3. June Report
    If I link the data from 2 and 3 into 1, and if i save 1 as July Report does the links stay the same?
    Basically what I want to do is take the three workbooks and use them for the 12 months in a year, change the data each month but have the data links change accordingly and easily, without creating all the files again. Any ideas?

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: links between workbooks

    Yes, if you have workbook 3 open when you do the SaveAs on the other two. As you could easily verify.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    05-12-2016
    Location
    spanaway
    MS-Off Ver
    2007
    Posts
    112

    Re: links between workbooks

    I didn't want to mess up my books, so to verify, if I have all the books open and I save them as JuLy Budget, July Production and July Reports - the links for June stay the same and change for July correct? So June's would stay intact? There is a lot of data.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: links between workbooks

    make links for all months and with LOOKUP month num (parameter, for example) take needed links

  5. #5
    Forum Contributor
    Join Date
    05-12-2016
    Location
    spanaway
    MS-Off Ver
    2007
    Posts
    112

    Re: links between workbooks

    do you mean the find/replace? and is there a feature to look through all of the book instead of going to page after page?

  6. #6
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: links between workbooks

    no, just worksheet functions
    Attached Files Attached Files

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: links between workbooks

    Quote Originally Posted by bugdout View Post
    I didn't want to mess up my books, ...
    As a matter of basic file hygiene, you should make the June workbooks read-only first, to avoid a mistake.
    Last edited by shg; 06-18-2016 at 02:22 PM.

+ 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. Update workbooks links witout opening the workbooks
    By no1freeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2015, 03:54 PM
  2. Links to other workbooks
    By aresquare1 in forum Excel General
    Replies: 3
    Last Post: 04-15-2013, 04:36 PM
  3. Links between workbooks
    By mmf in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2008, 02:28 AM
  4. How do you get rid of links to other workbooks?
    By gshock in forum Excel General
    Replies: 3
    Last Post: 09-03-2008, 05:48 PM
  5. Links to other workbooks??
    By mattcross55 in forum Excel General
    Replies: 3
    Last Post: 05-09-2008, 10:11 AM
  6. Links between workbooks
    By Eddie in forum Excel General
    Replies: 0
    Last Post: 04-18-2005, 11:06 AM
  7. Links to other workbooks
    By Darrell Wesley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 05:06 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