Forum Discussion
xls password error any way of copying the s/sheet to a new doc. without transferring locked cell
So my password is not working and I am unable to use my much needed spreadsheet - I am having a melt down. Is there a way to copy the sheet to to a new document with transferring the locked cells. ...
- If this is a worksheet password, Select all, copy, paste to new sheet. Values only are transferred for hidden formulas. If it's a workbook open password, only forensic hacking tools can open them. Can you back to an older backup?
If this is a worksheet password, Select all, copy, paste to new sheet. Values only are transferred for hidden formulas. If it's a workbook open password, only forensic hacking tools can open them. Can you back to an older backup?
Thanks P, it did not work but we were able to do a restore from a few days prior.
