Moonliner
05-19-2006, 07:47 AM
Here's the problem:
I have an excel file that has a seperate sheet for each employee showing their current leave balance.
For each employee I want to create a word document that links to their sheet and their sheet only inside that master file. The idea being that they can check on their leave whenever they want rather than have to pester accounting.
However when I create the link the user can use it to open the actual file and read all the other sheets. (ie double click in the word doc.)
Is there a way to show them their data and have it automatically update as the master file is updated, without them being able to see the entire file?
I have an excel file that has a seperate sheet for each employee showing their current leave balance.
For each employee I want to create a word document that links to their sheet and their sheet only inside that master file. The idea being that they can check on their leave whenever they want rather than have to pester accounting.
However when I create the link the user can use it to open the actual file and read all the other sheets. (ie double click in the word doc.)
Is there a way to show them their data and have it automatically update as the master file is updated, without them being able to see the entire file?