Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2010
    Location
    vancouver, wa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I created a spreadsheet and decided to password protect it. Later, I decided to just protect certain cells in certain worksheets and thought I would remove the workbook password. This has turned out to be harder than I thought.

    I looked into Help and performed the following steps:

    1.Use the password to open the spreadsheet.
    2.Click the Microsoft Office Button , point to Prepare, and then click Encrypt Document.
    3.In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
    4.Save the spreadsheet.

    I still get this dialog when I open the spreadsheet:

    Please help.

    Thanks,
    Steve
    Attached Images Attached Images

  2. #2
    New Lounger
    Join Date
    Dec 2010
    Location
    vancouver, wa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Well, apparently either no one here had any interest in this post or just didn't have a solution to the post. My impatience caused me to continue messing with the file and I finally found the solution.
    It seems that I had the "file protected". In order to remove this protection, I performed the following steps:

    1. "Save As" > "Excel Workbook"
    2. Click on "Tools" and select "General Options"
    3. Clear all passwords as shown below
    4. Click on OK.
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •