Ms Excel - Password Protected Cells
Thread poster: Susanna Garcia

Susanna Garcia  Identity Verified
Local time: 11:04
Italian to English
+ ...
Aug 31, 2011

I've just received some work in Excel, PM gone home, and I find the cells are password protected so can't copy/amend/nothing. Is there any way round this?

thanks


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 12:04
Member
French to English
+ ...
Sympathy! Sep 1, 2011

Oh dear, I've encountered exactly the same problem before, and on that occasion, I was unable to find a way round it — perhaps others more skilled with computers than I would be able to!

However, I was just wondering if you might be able to get round it if you can print the spreadsheet? If so, can you print it to PDF (if necessary, download a free PDF writer like Nitro PrimoPDF), then copy-and-paste the result into either a fresh .XLS or a .DOC or something — anything, to get you out of trouble?

Just a tiny idea, you'll have to see first of all if you can at least print the darned thing?!

PS: Have just tried the experiment, and it worked OK with a non-password-protected XLS, except that the cell formatting was lost. Depending on how complex your XLS is, that might or might not be a problem, and one that you could probably sort out (with patience!) by working in Word first, for example.



PPS: What seems to go wrong is that no tabs are inserted, so the columns are lost; if your spreadsheet is not too complex, I don't know if it might be possible to insert dummy columns between the existing columns (assuming, of course, that it will even allow you to do this!), filled with a special character, which in Word you could then search-&-replace with 'tab'. You could then convert text to table, and you'd have something more or less fit to paste back into a clean XLS.




[Modifié le 2011-09-01 00:21 GMT]


Direct link Reply with quote
 

Susanna Garcia  Identity Verified
Local time: 11:04
Italian to English
+ ...
TOPIC STARTER
SORTED! Sep 1, 2011

Tony, thanks but I found the solution by googling the problem!
I uploaded the file to Google Docs then downloaded it in .xls format and that did the trick. Much relief chez Garcia where one ancient cat wants her bed.
One more to go.

Suzi


Direct link Reply with quote
 

Teymur Suleymanov  Identity Verified
Local time: 06:04
Russian to English
+ ...
You can use some software to remove the password Sep 1, 2011

Susanna Garcia wrote:

I've just received some work in Excel, PM gone home, and I find the cells are password protected so can't copy/amend/nothing. Is there any way round this?

thanks


For starters, may I just say that I think it's pretty lousy for the PM to forget about such an important thing as a PW protection before going home...

However, clever people have long ago invented ways to crack the MS Office PW protection.
One way (among many) to do this is just to use a software called "Excel Password Remover PRO":
http://www.straxx.com/excel/PasswordPRO.html

I think the page says that the demo version is as good as the purchase one except some popups, but you only need this for a one time shot, and then you can go to Control Panel>Add/Remove Programs and uninstall it.

HTH
Teymur


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Ms Excel - Password Protected Cells

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search