EXCEL

[Tysonator]

Hello,

a colleague at work has password protected a spreadsheet tab & cells so data can not be written over.
However we need to amend the data as the rate have changed and he is not being helpful with the password, by saying he can not remember ! !

So is there any way I can get around password protection in Excel ?

many thanks

 

[Tysonator]

Can you open it as read only, and then save a copy?

I can open the xls and have tried coping the tab, however the password protection on cells is still active !

 

[Tysonator]

I guess you didnt read my reply then?

Hi, I have read your reply. I should mention I can not install any new software at work. However I can always bring the offening xls home and have a crack at it !

At work I have copied the tabs, the spreadsheet, renamed it, cut & pasted certian cells. However the password protected cells still remain !