0

I stupidly forgot my excel password to unlock the sheet. I'm running Excel for Office 365 MSO (16.12026.20334) 32-bit.

Thanks, any help would be greatly appreciated! Bryan

bryan8718
  • 11
  • 2
  • Does this answer your question? [Cracking Sheet Password with VBA](https://stackoverflow.com/questions/19953979/cracking-sheet-password-with-vba) – cybernetic.nomad Oct 31 '19 at 19:53
  • @cybernetic.nomad pretty sure that method was patched. – Mark S. Oct 31 '19 at 20:11
  • 1
    @Bryan8718 are you able to open the workbook, or is it locked at that level (vs. just locking an individual sheet). – Mark S. Oct 31 '19 at 20:12
  • @MarkS. Yes I can open the workbook, I just can't make any modifications or additions. It is a cash counting document for the till in my shop, and I'd like to add a line to it, but since I've locked everything except for the cells to input cash amounts, I can't make any changes. Thanks for your help – bryan8718 Nov 01 '19 at 23:52
  • @bryan8718 depending how you locked it you may be able to copy the data to a different, unlocked sheet and work from there – Mark S. Nov 05 '19 at 17:00
  • @MarkS. Yes, I tried that, but sadly no luck – bryan8718 Nov 07 '19 at 18:22

1 Answers1

1

Open a blank excel workbook. Now , Try to copy the contents from the sheet that was previously protected and paste it in the blank workbook sheet. Now try to save this new sheet in .csv format and everything works as it was

Sohith
  • 11
  • 1