 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Password Protection Not Prompting Certain Users
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. > 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 [quoted text clipped - 6 lines] > > Anyone ever hear of something like this?  SignatureDave Peterson 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. > What kind of password protection are you using? > [quoted text clipped - 24 lines] > > > > Anyone ever hear of something like this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.