[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

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?
  • 2
2 Solutions
Glenn RayExcel VBA DeveloperCommented:
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,
MontoyaProcess Improvement MgrAuthor Commented:
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?
Glenn RayExcel VBA DeveloperCommented:
There's no built-in function - besides the password access - that will limit access to an Excel file.  You can do this with VBA, checking the username against a list of defined names (either embedded in the workbook or VBA module), but that's a little more involved.  I used that functionality to define and control user type in some applications (ex., "users" and "superusers").

Depending on the version of Excel that you use, there is a provision to permit only certain users to edit certain ranges. In Excel 2013, you access this feature on the Review...Allow Users to Edit Ranges menu item. You will then raise this dialog:
Allow Users to Edit Ranges dialogIf you click the New... button on that dialog, you will see a dialog that lets you specify the protected range
New protected range dialogIf you then click the Permissions... button on that dialog, you will see a dialog that lets you specify the permissions
Permissions for protected range dialogIf you then click the Add... button on that dialog, you can specify users or groups that correspond to that permission:
Select Users or Groups dialog
Excel also has a way of restricting access using the Review...Shared Workbook menu item. Shared Workbooks are notorious for (eventually) resulting in file corruption if multiple users edit the workbook simultaneously. Use of the Shared Workbook feature is discouraged by experts in pretty much every Excel help forum in the world for this reason.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now