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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks