PDA

View Full Version : It's my turn.. Excel Help needed...


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?

Ghoulish Delight
05-19-2006, 08:10 AM
Well, if you view the "Database" toolbar, click "Insert Database" and follow the wizard, it should work. But for some reason whe I try it, it isn't updating the data as it changes, even though the help says it should.

Moonliner
05-19-2006, 08:34 AM
Well, if you view the "Database" toolbar, click "Insert Database" and follow the wizard, it should work. But for some reason whe I try it, it isn't updating the data as it changes, even though the help says it should.

Ahh but it does work. As long as you select the "insert as field" option. Then all I need to do is create an on-open word macro that does a Select-All and F9 to update the fields.

Bravo!