I have a document in a department shared drive. I want to create another copy of this document and put it in another drive for a user to access whenever he wants. BUT I want the copied document to update automatically when the original is updated ( it is a spreadsheet). The user for the copied document will not be getting access to the original document because it is in a drive that has many other documents that he is not supposed to see. So we need to create a copy that user can review and will have the updated info always available. What is the best way to do this. I read about linking but that does not seem to apply to the entire worksheet but to parts of it. Thanks.
Bookmarks