I have an excel file which is an energy calculator, the file was made by a works colleague (now unfortunately deceased) but in ORDER to prove the calculation to an energy body they have to view the internal calculations used but I can't get into it, the file has been locked.
Is there anyway I can unlock the file to obtain the information? When you say "locked" do you get an error MESSAGE saying it's locked? Was it created on your computer or the file creators and then copied to yours?

If the latter, and you're running XP, right-click the file / properties / security / advanced / owner tab. Who is listed as the owner? If not you, go BACK one step and add yourself as a user, then go forward and change ownership to yourself.

Alan <>< If anything else fails, you can try free on-line Excel unlocking service:
http://www.ensode.net/xls-crack.jsfale52,
The file was created on another computer, my PROBLEM OCCURS when I go into Tools, Protection, Unprotect sheet or workbook I'm asked for a password - which I obviously can't insert as I don't know it.
I am running XP but if I try what you have suggested I can only - R/Click, properties, the only 3 tabs which appear are General/Custom/Summary therefore the entire routine you request to be completed can't be done! Any further suggestions?

Broni,
Tried the on-line Excel unlocking service - followed the simple instructions, but nothing happened, any further suggestions? Try here: http://software.techrepublic.com.com/download.aspx?docid=300350
You have to register for free.Broni,
Thanks for the link - Downloaded the Excel cracker software programme, set it up, let it work on the file (for almost 72 hrs!). Unfortunately it didn't manage to crack the code!

Anyone else with any ideas?With two tries, with two different tools, and no results....file itself may be corrupted.
Maybe someone else will come up with some other solution.
Sorry, I tried.Thanks again.No prob.