+ Reply to Thread
Results 1 to 2 of 2

Thread: linking my worksheet to network shared copy

  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    linking my worksheet to network shared copy

    I work in an Excel worksheet on my computer. A copy of the worksheet is in a Shared folder on my company network. Can I link the two worksheets so that when I update my worksheet, the other one automatically updates?

  2. #2
    Forum Guru TMShucks's Avatar
    Join Date
    07-15-2010
    Location
    Manchester, England
    MS-Off Ver
    MSO 2003 & 2007
    Posts
    6,196

    Re: linking my worksheet to network shared copy

    I suspect not. For the network copy to reflect changes in your workbook, the link(s) would actually have to be in the shared workbook. The problem there is, how would changes to the shared workbook made by others be reflected in your workbook?

    You could maybe use a Change event to monitor cells in your workbook and update the shared copy.

    Regards, TMS

+ 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