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