View Single Post
Old 05-19-2006, 07:47 AM   #1
Moonliner
8/30/14 - Disneyland -10k or Bust.
 
Moonliner's Avatar
 
Join Date: Jan 2005
Posts: 9,022
Moonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of cool
Send a message via AIM to Moonliner Send a message via MSN to Moonliner Send a message via Yahoo to Moonliner
It's my turn.. Excel Help needed...

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?
__________________
- Taking it one step at a time.
Moonliner is offline   Submit to Quotes Reply With Quote