excel urgent help

Camalot · 20 Dec 2008 at 10:54

My supervisor needs to change a cell that holds the budget hours but it keeps saying its locked, when she clicks unlock spreadsheet it asks for a paasword. Neither of us have the old managers number, is there any other way to change the cell?

Cheers.

paradigm · 20 Dec 2008 at 11:16

If you can open the workbook without a password, odds are you can use a macro based crack to unlock cells/worksheets.

Have a quick google for macro excel password, and something useful will crop up.

swinnie · 20 Dec 2008 at 11:17

Any of these any good?

http://www.google.co.uk/search?hl=en&q=spreadsheet+cell+password+++unlocker&btnG=Google+Search&meta=

Camalot · 20 Dec 2008 at 11:26

I cant download anything, only net access i have is my phone.

Dolph · 20 Dec 2008 at 11:28

Then you're got a big problem. You could try copying the data into a new spreadsheet, but if there's macros or lots of formulas in it it might not work very well.

Camalot · 20 Dec 2008 at 13:15

I'm home now, thanks for the replies.

I've found my old managers number out, so I've text it to my supervisor so she can phone him.

If hes changed numbe, or doesn't remember it. I read you can open the spreadsheet in Open Office, then re-save it again to remove the password?

Thanks again guys.