Ms Excel - Password Protected Cells
Thread poster: Susanna Garcia

Susanna Garcia  Identity Verified
Local time: 18:57
Italian to English
+ ...
In memoriam
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


 

Tony M
France
Local time: 19:57
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
... See more
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]
Collapse


 

Susanna Garcia  Identity Verified
Local time: 18:57
Italian to English
+ ...
TOPIC STARTER
In memoriam
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


 

Teymur Suleymanov  Identity Verified
Local time: 13:57
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


 


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






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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