Password Protection Not Prompting Certain Users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We had an interesting issue present itself in the last couple of days. We
have 4 files that are password protected that are located within the same
folder. Previously about 5-7 people were using the files and each time they
opened the file they were prompted for the password. Two new staff started
Monday that do not need access to these files at present. For some reason if
they attempt to open any of the 4 files the files simply open; no prompt is
ever displayed. The password protection is still in effect as if any of the
old staff try to access the files they are prompted.

Anyone ever hear of something like this?
 
What kind of password protection are you using?

If you used "Password to Open" under file|saveas|tools|general options), then
this response is wrong and I don't have a guess.

But if you used a "password to modify" (under file|saveAs|tools|General
options), then if the user doesn't supply the correct password, they can still
open the file in readonly mode.

When those users open the workbook, do you see [ReadOnly] in the title bar?

If you do, then I'm guessing that the new users have read access to that
drive/folder, but they don't have write access to that folder.

If that's the case, then excel works with windows and knows that the user can't
save in the same location--so it knows that the best this user can do is open in
readonly mode--and doesn't bother asking.
 
Just realized that the user who created the files made them password
protected to modify like you suggested. The new users who attempt to open
the file open it in read-only mode even though they don't get prompted.
Looks like this one is resolved.

Dave Peterson said:
What kind of password protection are you using?

If you used "Password to Open" under file|saveas|tools|general options), then
this response is wrong and I don't have a guess.

But if you used a "password to modify" (under file|saveAs|tools|General
options), then if the user doesn't supply the correct password, they can still
open the file in readonly mode.

When those users open the workbook, do you see [ReadOnly] in the title bar?

If you do, then I'm guessing that the new users have read access to that
drive/folder, but they don't have write access to that folder.

If that's the case, then excel works with windows and knows that the user can't
save in the same location--so it knows that the best this user can do is open in
readonly mode--and doesn't bother asking.


We had an interesting issue present itself in the last couple of days. We
have 4 files that are password protected that are located within the same
folder. Previously about 5-7 people were using the files and each time they
opened the file they were prompted for the password. Two new staff started
Monday that do not need access to these files at present. For some reason if
they attempt to open any of the 4 files the files simply open; no prompt is
ever displayed. The password protection is still in effect as if any of the
old staff try to access the files they are prompted.

Anyone ever hear of something like this?
Click to expand...
Click to expand...
 
Back
Top