Microsoft Excel Question

[Serenity]

So, I have this excel worksheet I was sent. It's fantastic, but there are two cells out of the entire thing I need to change. Problem is, the sheet is password protected, and no one even knows who created it to try to track down the password. Long story short, is there any way to unprotect the workbook without loosing the data?

[Bizman]

Is it password protected or just locked against unintentional changes? In the latter case all it takes is to unlock it. How to do it depends on your version of Excel, the help function should tell you how.

[Serenity]

Is it password protected or just locked against unintentional changes? In the latter case all it takes is to unlock it. How to do it depends on your version of Excel, the help function should tell you how.

Sadly, it IS password protected...

[Shuffler]

What version of excel?

Also you said the sheet is password protected but then say workbook. Is it just the sheet protected or is it the workbook?

[Zoney]

Maybe you can just copy and paste all the cells into a new worksheet and then change those few things you need to.

[Bizman]

Maybe you can just copy and paste all the cells into a new worksheet and then change those few things you need to.

That sounds like a viable solution. Ctrl+A for selecting everything, then copy the selected and paste it into A1. If that doesn't work, crop an area similar to the original one and paste it there.

[Serenity]

I'll try copying everything!

What version of excel?

Also you said the sheet is password protected but then say workbook. Is it just the sheet protected or is it the workbook?

The latest, whichever that is lol.

[SIK1]

You have to make sure that you get the formulas, if there are any associated with the columns. It's been awhile since I've had to work with excel but I think you need to have the formulas in place before you transfer your data.

 
Sik

[Serenity]

You have to make sure that you get the formulas, if there are any associated with the columns. It's been awhile since I've had to work with excel but I think you need to have the formulas in place before you transfer your data.

 
Sik

THAT is gonna be a nightmare.

This is basically an excel sheet to spit out a jet-log, so it's a BUNCH of fuel/wind/distance/altitude/etc. calculations.

[Easyscor]

In Excel, there is a Paste Special... submenu. A Dialog box appears. The options are, Formulas, Values, Formats, ...

If you can copy/paste from the original to a new workbook, that's what I'd try. I have no idea if Excel will let you copy from a protected workbook. If it will, then copy, then Paste Special Values, then Formula, then Format.

Good luck.

 

[bustr]

Have you tried any of the freeware excel password recovery utilities available on the Internet yet? I've used those to access spread sheets of employees who forgot to hand over "all" access before they moved on. It's worth a few downloads and installs to see.

[Serenity]

This: http://geeknewscentral.com/2013/11/10/unprotecting-excel-spreadsheets-without-a-password/

was recommended to me, and it worked perfectly for anyone else having a similar problem.