We had a Excel file that we needed to copy some of the cells to recreate a new proposal. The Excel file was locked, so we could view it but couldn’t copy anything.

I found the following link that helped me unlock the document.

https://www.ablebits.com/office-addins-blog/2016/02/10/protect-unprotect-excel-sheet-password/

I had to use the script and the VBA code to get a temporary password. This temp password allowed me to edit the document and do a Save As.

Let us know if this helps you…