+ Reply to Thread
Results 1 to 2 of 2

Thread: linking several workbooks so they still work together when renamed

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    NV
    MS-Off Ver
    Excel 2007
    Posts
    1

    linking several workbooks so they still work together when renamed

    Hi all,
    I have 4 Excel workbooks that I would like to have all work together.

    They are for tracking what I have done on my clients sites and are named as follows:
    Client Checklist Master
    Client Accounts Master
    Client Reviews Master
    Client Site Master

    The Client Checklist master links to the others at various points, as well as having internal links between worksheets. I just finished these and realized that I do not know how to make the following happen.

    When I rename them from "CLIENT Checklist Master " to "PLUMBER Checklist" they all keep the existing link structure intact.

    I need to be able to change the names, put them into the clients folder on my desktop and have them retain the interior links.
    Thanks for any help y'all can provide.

    Profitably Yours,
    Eric

  2. #2
    Valued Forum Contributor
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2007
    Posts
    996

    Re: linking several workbooks so they still work together when renamed

    If you open all the linked work books at the same time, and then save-as with the new name/names, the links will be saved to the new names

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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.2.0