asked on

user's can no longer edit Excel worksheet

One file.
two worksheets.

Users were able to edit areas of the worksheet until recently. They can no longer do that. When they try to edit, they are prompted with a password. The sheet was always protected, but the users claim they never had to enter a password.

Any ideas?

Glenn Ray

I never believe users who say "I never had to enter a password before!" :-)

One is never immediately prompted to enter a password after a workbook is opened and attempts are made to edit in locked, protected cells. A message will pop up stating "The cell or chart that you are trying to change is protected and therefore read-only."

Now, if they click "Unprotect Sheet" and a password has been entered previously, then they'll have to enter the password. It is quite possible that until recently this sheet had been protected without a password, but then someone - accidentally or on purpose - entered a password and saved the file.

You'll either need to find out what the password was from the individual or crack the password yourself. There are several free utilities available on the Internet that you can use to do this. As a rule, I do not crack password-protected files here on EE; it is too risky.

When you do finally get the sheet unlocked, you'll need to re-protect the sheet WITHOUT a password once again, or just forego using one at all.

Good Luck,
-Glenn

Montoya

ASKER

I unlocked the sheet a few days ago... what I was looking for is:

Is there a way to have a list of users that can access/edit a file? I wanted to be sure that there ISNT a feature I did not know about. Is there?

SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

byundt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial