Question Locked

PW Protection on Excel file does not prevent over-writing

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

We have department checkbook Excel files on a shared network drive. I have added password (PW) protection to modify the files. Sounds good, right? But this does not prevent the entire file from being over-written by anyone who has access to the folder. The User does have to select YES to "this file already exists, do you want to replace it" but that's not much of a safeguard. And when the file is over-written, all PW protection or cell protection is over-written as well.

Suggestions??

3 replies

by timbrewolf

Depending on how your network is setup (WinXP/2k3), you can right-click on the file and select the "Security" tab.

From there, you can remove permissions from "Everyone" or "Users" and just allow access to the domain users that you want to be able to access the file.

I believe that works with a Workgroup as well, but we use it in a Domain.

Setting security permissions this way ensures that regardless of the password, unauthorized users cannot interact with that file at all.

Hope that helps! :)

by debbi.moore

I have security on the folders but I'm trying to protect the files from the people who do have permissions to access.

This discussion is closed to new replies.