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

Excel Password

An employee that is no longer here has password protected an Excel 2010 spreadsheet.  What is the best way to get this file open?
0
ACA_Infrastructure
Asked:
ACA_Infrastructure
  • 4
  • 3
3 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
What kind of protection? Workbook? Worksheet? VBA?

Kevin
0
 
ACA_InfrastructureAuthor Commented:
I believe it to be just a worksheet
0
 
zorvek (Kevin Jones)ConsultantCommented:
Experts Exchange prefers that we do not post methods for unlocking worksheets and workbooks without the password, but, in the case of Excel, posting a link to another site that publicly displays the technique is acceptable. You will find complete instructions for unlocking a workbook or a worksheet without the password at http://www.zorvek.com/excel/unlocking-workbooks-and-sheets.htm.

Kevin
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ACA_InfrastructureAuthor Commented:
We were able to get find the password!  Now can we set the spreedsheet to never be protected again or does that have to be done by GPO?
0
 
zorvek (Kevin Jones)ConsultantCommented:
You can't prevent someone from protecting a worksheet unless you lock the workbook structure.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
Actually, the user can still protect the worksheet if the workbook structure is protected.

So, it looks like you will have to resort to other means outside of the available Excel options.

Kevin
0
 
ACA_InfrastructureAuthor Commented:
This issue is resolved.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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