Remove the Password When Opening a Spreadsheet

Removes the password when opening an Excel spreadsheet. You must know (and supply) the correct password for this script to work.

Add to favorites
E-mail Twitter Digg Facebook
  • EXCEL file is READ ONLY
    1 Posts | Last post April 25, 2017
    • Hi Kent,
      Thank you so much for such a great script. This is working AS IT IS for me.
      Just one issue, whenever I use the password unprotected file saved by this powershell script via SSIS DATA flow task (version 2008 R2); I get an error as "Cannot update.  Database or object is read-only.".
      Can you please shade some light?