Forgot password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I protected a worksheet so I could accept any changes made. Now I have
forgotten my password. I tried to save it as a different copy it but the
format followed.
 
Good morning Sweetsue516

Try this:

Open your file. Create a blank new workbook. For each sheet in you
protected workbook, click in the top left hand corner to highlight th
whole sheet, right click and copy and then cross to the new workboo
and copy your sheets in one by one. Then save your newly recreate
sheet. If you've got a number of sheets it might be a bit of a pai
and you may lose some aspects like custom views, or complicate
formulae referencing external sources, but if you've got a relativel
simple straightforward workbook it should be OK.

HTH

Dominic
 
Back
Top