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...

    Upcoming CPE Webinars

    Jul 16
    Hand off work to others with finesse and success. Kristen Rampe, CPA will share how to ensure delegated work is properly handled from start to finish in this content-rich one hour webinar.
    Jul 17
    This webcast will cover the preparation of the statement of cash flows and focus on accounting and disclosure policies for other important issues described below.
    Jul 23
    We can’t deny a great divide exists between the expectations and workplace needs of Baby Boomers and Millennials. To create thriving organizational performance, we need to shift the way in which we groom future leaders.
    Jul 24
    In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.