Excel Tip: Revising Protected Files Without the Password

A question was recently submitted by Barry Shrut, who wanted to know if there is a way he can revise a protected workbook when the password left with a departed employee. This tip may do the trick!

Although you can't make changes to protected cells in a workbook when you don't have the password, you can copy the entire workbook to a new workbook file and the protection will not carry over to the new file.

  • Select the occupied cells in the current worksheet. If you prefer, you can select the entire worksheet by clicking the "Select All" button which appears as a blank box above the row number 1 and to the left of the column letter A. All cells will be selected, including those that are protected.

    Note: If the workbook contains information on more than one sheet, select all utilized sheets by clicking on the first sheet tab, pressing the Shift key, and clicking on the sheet tab for the last sheet containing data.

  • Execute a Copy command by clicking the Copy button on the standard toolbar, pressing Ctrl+C, or choosing Edit, Copy from the menu. All selected matter will be copied.

  • Open a new workbook.

  • Execute a Paste command by clicking the Paste button on the standard toolbar, pressing Ctrl+V, or choosing Edit, Paste from the menu. All selected material from the protected workbook will appear in the new workbook, with formulas intact. No protection will exist in the new workbook, so you will have access to all cells.

  • If the protected worksheet contained hidden rows or columns, these hidden areas will copy to the new workbook as well, assuming your original selection area overlapped the hidden areas. To view hidden material in the new workbook, select flanking columns or rows (for example, if Column C is hidden, select columns B and D), then choose Format, Column (or Row), Unhide from the menu. The hidden material will be displayed.
  • View more helpful tips!

    You may like these other stories...

    By Jason Bramwell When CPA Barry MacQuarrie started the SocialCPAs Social Media Survey in 2010, he said social networking was still relatively new to the accounting profession. The self-proclaimed "social media...
    By Jason Bramwell In an effort to address the increased demand for comprehensive and intensive training on eXtensible Business Reporting Language (XBRL), the American Institute of CPAs (AICPA) and XBRL US Inc., the not-...
    By Lauren Prosser, Director of ProfitCents Professional Services, Sageworks Staffing is among the top management issues facing CPA firms, according to a recent survey by Sageworks, a financial information company. That...

    Already a member? log in here.

    Upcoming CPE Webinars

    Oct 30Many Excel users have a love-hate relationship with workbook links.
    Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
    Nov 18In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets.
    Nov 19How do you minimize redundant work and unnecessary steps to maximize the amount of work moving through your firm?