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.

 
 
 
 
 
(0)
Add to favorites
Office
8/10/2009
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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?