Software

Ask something
Question Locked

Linking a password protected document

0 helpful
2 replies

by rwalker11

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I designed an excel document for a few people in my department. The document will be in a shared directory, so I gave each one a password to open their document. I need the totals so I want to link an excel file, the problem is - when I go to update the link, it asks me for the individual's password. Is there a way around this? I will have too many files to enter a password. What can I do?

Thanks

2 replies

by tig2

If you want your team to only update their part of the doc, you will have to have each password to open the doc.

The folder is a share but consider making the doc a share. You will have to have specific naming for each person's copy and you will need to get a domain level resource involved.

Basically, you establish a private share between yourself and the end user for their specific file. That turns the file into an access required file. The only users in the group for each file would be you and the end user.

This takes care of the need to pass protect each instance of the feeder files and is only moderately kludgy.

Another "solution" would be for each user to email you their updates. Not so great, but workable.

Someone else may have a better suggestion!

Good luck

This discussion is closed to new replies.